Skip to content
VS Code

Secure Schema MCP for VS Code

io.github.siddharth-coder13/secure-schema

Read-only MCP server for exposing database schema metadata without row data.

client:VS Code transport:stdio runtime:pypi

Install Secure Schema MCP in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "database-url",
      "description": "DATABASE_URL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "database-schema",
      "description": "DATABASE_SCHEMA",
      "password": true
    },
    {
      "type": "promptString",
      "id": "allowed-tables",
      "description": "ALLOWED_TABLES",
      "password": true
    },
    {
      "type": "promptString",
      "id": "secure-schema-env",
      "description": "SECURE_SCHEMA_ENV",
      "password": true
    },
    {
      "type": "promptString",
      "id": "fastmcp-check-for-updates",
      "description": "FASTMCP_CHECK_FOR_UPDATES",
      "password": true
    },
    {
      "type": "promptString",
      "id": "fastmcp-show-server-banner",
      "description": "FASTMCP_SHOW_SERVER_BANNER",
      "password": true
    }
  ],
  "servers": {
    "secure-schema": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-secure-schema"
      ],
      "env": {
        "DATABASE_URL": "${input:database-url}",
        "DATABASE_SCHEMA": "${input:database-schema}",
        "ALLOWED_TABLES": "${input:allowed-tables}",
        "SECURE_SCHEMA_ENV": "${input:secure-schema-env}",
        "FASTMCP_CHECK_FOR_UPDATES": "${input:fastmcp-check-for-updates}",
        "FASTMCP_SHOW_SERVER_BANNER": "${input:fastmcp-show-server-banner}"
      }
    }
  }
}

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

Secure Schema MCP in other clients