Skip to content
VS Code

universal db mcp for VS Code

io.github.fashad-ahmed/universal-db-mcp

Security-first MCP server for PostgreSQL, SQLite, MySQL, DuckDB with SQL injection prevention.

client:VS Code transport:stdio runtime:pypi

Install universal db mcp in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "postgres-uri",
      "description": "POSTGRES_URI",
      "password": true
    },
    {
      "type": "promptString",
      "id": "sqlite-path",
      "description": "SQLITE_PATH",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mysql-uri",
      "description": "MYSQL_URI",
      "password": true
    },
    {
      "type": "promptString",
      "id": "duckdb-path",
      "description": "DUCKDB_PATH",
      "password": true
    },
    {
      "type": "promptString",
      "id": "allow-destructive",
      "description": "ALLOW_DESTRUCTIVE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "max-result-rows",
      "description": "MAX_RESULT_ROWS",
      "password": true
    }
  ],
  "servers": {
    "universal-db-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "universal-db-mcp"
      ],
      "env": {
        "POSTGRES_URI": "${input:postgres-uri}",
        "SQLITE_PATH": "${input:sqlite-path}",
        "MYSQL_URI": "${input:mysql-uri}",
        "DUCKDB_PATH": "${input:duckdb-path}",
        "ALLOW_DESTRUCTIVE": "${input:allow-destructive}",
        "MAX_RESULT_ROWS": "${input:max-result-rows}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

universal db mcp in other clients