Secure Schema MCP
A read-only MCP server that gives AI coding tools database structure without exposing row data. It returns table and view names, columns, types, keys, and relationships in a compact format designed to reduce LLM token usage.
Power your agent
คำสั่งของผู้เผยแพร่เอง ไม่ใช่เอนด์พอยต์ของ PlugMCP
Host a copy with our keys and logs.
uvx mcp-secure-schema==1.0.1Claude Code ไม่มีลิงก์ติดตั้งสำหรับคำสั่งแบบโลคัล ให้คัดลอกคำสั่งด้านล่างแล้วรันในเทอร์มินัล
DATABASE_URL=<secret> DATABASE_SCHEMA=<value> ALLOWED_TABLES=<value> SECURE_SCHEMA_ENV=<value> FASTMCP_CHECK_FOR_UPDATES=<value> FASTMCP_SHOW_SERVER_BANNER=<value> claude mcp add io.github.siddharth-coder13-secure-schema -- uvx mcp-secure-schema==1.0.1รันในเทอร์มินัล
{ "mcpServers": { "io.github.siddharth-coder13-secure-schema": { "command": "uvx", "args": [ "mcp-secure-schema==1.0.1" ], "env": { "DATABASE_URL": "<secret>", "DATABASE_SCHEMA": "<value>", "ALLOWED_TABLES": "<value>", "SECURE_SCHEMA_ENV": "<value>", "FASTMCP_CHECK_FOR_UPDATES": "<value>", "FASTMCP_SHOW_SERVER_BANNER": "<value>" } } }}claude_desktop_config.json
URL แบบรีโมตหรือคำสั่งบนเครื่องของคุณ? การติดตั้งสองแบบต่างกันอย่างไร
รันบน PlugMCP
A new server you create. It is not this listing's official endpoint. Use the publisher install when you want their URL and their credentials.
เปิดจากผู้เผยแพร่
A read-only MCP server that gives AI coding tools database structure without exposing row data. It returns table and view names, columns, types, keys, and relationships in a compact format designed to reduce LLM token usage.
Read-only MCP server for exposing database schema metadata without row data.
| Exposed | Not exposed |
|---|---|
| Table and view names | Row values or query results |
| Column names and SQL types | Row counts or samples |
| Primary and unique keys | Database credentials |
| Foreign-key relationships | Write or query tools |
Schema metadata can still be sensitive. A column name such as ssn reveals information even without values, so production deployments should always use the table allowlist and a dedicated database account.
uvxSQLite support uses Python's built-in driver. PostgreSQL and MySQL drivers are included. Other SQLAlchemy dialects are not tested or bundled in v1.
The recommended setup uses uvx to download and run the published Python package in an isolated environment. You do not need to clone this repository or start the server separately. Your IDE launches it over stdio when needed.
Add this server to your Cursor MCP configuration:
{
"mcpServers": {
"secure-schema": {
"command": "uvx",
"args": ["mcp-secure-schema"],
"env": {
"DATABASE_URL": "postgresql+psycopg2://schema_reader:password@localhost:5432/appdb",
"DATABASE_SCHEMA": "public",
"ALLOWED_TABLES": "users,orders,products",
"SECURE_SCHEMA_ENV": "production",
"FASTMCP_CHECK_FOR_UPDATES": "off",
"FASTMCP_SHOW_SERVER_BANNER": "false"
}
}
}
}
Restart or reload Cursor after changing its MCP configuration.
Add this to ~/.codex/config.toml or a trusted project's .codex/config.toml:
[mcp_servers.secure-schema]
command = "uvx"
args = ["mcp-secure-schema"]
enabled_tools = ["schema_overview", "list_tables", "inspect_table"]
startup_timeout_sec = 30
tool_timeout_sec = 30
[mcp_servers.secure-schema.env]
DATABASE_URL = "postgresql+psycopg2://schema_reader:password@localhost:5432/appdb"
DATABASE_SCHEMA = "public"
ALLOWED_TABLES = "users,orders,products"
SECURE_SCHEMA_ENV = "production"
FASTMCP_CHECK_FOR_UPDATES = "off"
FASTMCP_SHOW_SERVER_BANNER = "false"
If you prefer a persistent installation:
pipx install mcp-secure-schema
Then use "command": "mcp-secure-schema" with an empty args list in the IDE configuration.
Secure Schema MCP accepts SQLAlchemy connection URLs:
# SQLite (absolute path)
sqlite:////Users/me/project/app.db
# PostgreSQL
postgresql+psycopg2://user:password@localhost:5432/appdb
# Remote PostgreSQL with certificate verification
postgresql+psycopg2://user:[email protected]:5432/appdb?sslmode=verify-full&sslrootcert=/path/to/ca.pem
# MySQL
mysql+pymysql://user:password@localhost:3306/appdb
Percent-encode special characters in URL usernames and passwords. For example, @ in a password becomes %40.
Local and remote databases use the same MCP configuration. For remote databases, the machine running the IDE must also have working DNS, network access, firewall permission, and valid TLS settings.
DATABASE_SCHEMA selects the default namespace. Resolution works as follows:
DATABASE_SCHEMA is a security boundary and tool arguments cannot override it.schema argument overrides DATABASE_SCHEMA.For strict production access to multiple schemas, run one MCP server entry per schema with its own DATABASE_SCHEMA and ALLOWED_TABLES values. The table allowlist contains unqualified names, not schema.table values.
schema_overview: compact map of permitted tables, views, primary keys, and foreign-key relationshipslist_tables: permitted table and view inventoryinspect_table: columns, SQL types, nullability, primary keys, unique constraints, and foreign keys for one entityEvery tool defaults to format="compact" for lower token usage:
tables:orders,users | pk:orders(order_id);users(user_id) | fk:orders.user_id->users.user_id
Pass format="markdown" when a human-readable table is more useful.
DATABASE_URL from an OS keychain or secret manager.Example PostgreSQL role:
CREATE ROLE schema_reader LOGIN PASSWORD 'use-a-secret-manager';
GRANT CONNECT ON DATABASE appdb TO schema_reader;
GRANT USAGE ON SCHEMA public TO schema_reader;
Metadata visibility varies by PostgreSQL provider and database policy. Grant only the additional catalog or object privileges required for inspection; avoid granting row SELECT unless your environment requires it.
The server exits immediately
Check the IDE's MCP logs. DATABASE_URL is mandatory, and production mode also requires a non-empty ALLOWED_TABLES value.
No tables or views are discovered
Confirm DATABASE_SCHEMA, exact table-name casing, database permissions, and whether the allowlist contains the expected names.
The connection URL fails with a valid password
Percent-encode reserved URL characters or use a secret-injection wrapper. Do not paste real credentials into issues or logs.
uvx is not found
Install uv using its official instructions, or install the package with pipx and use mcp-secure-schema as the command.
Starting the command appears to hang
That is normal for a stdio MCP server. It waits for an MCP client on standard input and is normally started by the IDE.
Clone the repository only when developing or testing the server:
git clone https://github.com/Siddharth-coder13/secure_schema_mcp.git
cd secure_schema_mcp
uv sync --extra dev
uv run python tests/demo_database.py
DATABASE_URL="sqlite:///$PWD/test_schema.db" uv run mcp-secure-schema
Run the test suite:
uv run pytest
Run the opt-in PostgreSQL integration test against a disposable database. The test creates and removes a randomly named schema:
POSTGRES_TEST_DATABASE_URL='postgresql+psycopg2://user@localhost:5432/testdb' \
uv run pytest tests/test_postgres_smoke.py -v
The tests verify row-data isolation, allowlist behavior, sanitized errors, compact output, relationships, schema selection, and the locked production namespace.
Maintainers should update the matching versions in pyproject.toml and server.json, run the complete SQLite and PostgreSQL suites, build with uv build --no-sources, verify installation from the wheel, publish to PyPI, and only then publish server.json to the MCP Registry.
Licensed under the Apache License 2.0. See LICENSE and NOTICE.
Read-only MCP server for exposing database schema metadata without row data.
{ "mcpServers": { "io.github.siddharth-coder13-secure-schema": { "command": "uvx", "args": [ "mcp-secure-schema==1.0.1" ], "env": { "DATABASE_URL": "<secret>", "DATABASE_SCHEMA": "<value>", "ALLOWED_TABLES": "<value>", "SECURE_SCHEMA_ENV": "<value>", "FASTMCP_CHECK_FOR_UPDATES": "<value>", "FASTMCP_SHOW_SERVER_BANNER": "<value>" } } }}เครื่องมือ
ยังไม่มีรายการเครื่องมือ เซิร์ฟเวอร์แบบรีโมตจะได้รายการหลังการตรวจสอบสถานะครั้งแรก
FAQ
คัดลอกคอนฟิก stdio สำหรับ Cursor, Claude Desktop, Claude Code หรือ VS Code ได้ในหน้านี้ คอนฟิกนี้ใช้การติดตั้งของผู้เผยแพร่ ไม่ใช่พร็อกซีของ PlugMCP
ผู้เผยแพร่ระบุตัวแปรสภาพแวดล้อมเหล่านี้: DATABASE_URL, DATABASE_SCHEMA, ALLOWED_TABLES, SECURE_SCHEMA_ENV, FASTMCP_CHECK_FOR_UPDATES, FASTMCP_SHOW_SERVER_BANNER
Secure Schema MCP ทำงานแบบโลคัลผ่าน stdio
ตรวจสอบล่าสุดเมื่อ 2026-11-09 Read-only MCP server for exposing database schema metadata without row data.