databases_mcp_server

databases_mcp_server

3.1

If you are the rightful owner of databases_mcp_server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

This MCP Server connects to various databases and performs queries using natural language.

Created a MCP Server that connects to databases(currently sqlite, mysql, postgresql and sqlserver) and perform queries on them automatically with natural language.


Usage with VS Code

For Mysql
"mcp": {
        "inputs": [],
        "servers": {
            "mysql": {
            "command": "node",
            "args": [
                "absolute/path/to/index.js", 
                "--mysql",
                "--host","host",
                "--database","database",
                "--user","user",
                "--password","password",
                ]
            }
        }
    }

For Sqlite
"mcp": {
        "inputs": [],
        "servers": {
            "sqlite": {
            "command": "node",
            "args": [
                "absolute/path/to/index.js", 
                "absolute/path/to/database.db",
                ]
            }
        }
    }

For Postgresql
"mcp": {
        "inputs": [],
        "servers": {
            "mysql": {
            "command": "node",
            "args": [
                "absolute/path/to/index.js", 
                "--postgresql",
                "--host","host",
                "--database","database",
                "--user","user",
                "--password","password",
                "--ssl","true",
                ]
            }
        }
    }

For Sqlserver
"mcp": {
        "inputs": [],
        "servers": {
            "mysql": {
            "command": "node",
            "args": [
                "absolute/path/to/index.js", 
                "--sqlserver",
                "--server","server",
                "--database","database",
                "--user","user",
                "--password","password",
                ]
            }
        }
    }