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