Schema | Secure Schema MCP

Secure Schema MCP

Describes the environment variables required to run the server.

Name	Required	Description	Default
`DATABASE_URL`	Yes	SQLAlchemy connection URL. Treated as a secret by the registry manifest.
`ALLOWED_TABLES`	No	Comma-separated, case-sensitive table and view allowlist. Production mode refuses to start without it.
`DATABASE_SCHEMA`	No	Default schema or catalog namespace. Recommended for PostgreSQL. Locked against tool overrides in production.
`SECURE_SCHEMA_ENV`	No	Set to 'production' or 'prod' for strict startup validation.	development
`FASTMCP_CHECK_FOR_UPDATES`	No	Set to 'off' for predictable stdio startup.
`FASTMCP_SHOW_SERVER_BANNER`	No	Set to 'false' to suppress the startup banner.

Features and capabilities supported by this server

Capability	Details
`tools`	{ "listChanged": true }
`logging`	{}
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`extensions`	{ "io.modelcontextprotocol/ui": {} }
`experimental`	{}

Functions exposed to the LLM to take actions

Name	Description
list_tablesA	Lists all user tables and views available in the current database. Use this to understand what architectural entities exist.
schema_overviewA	Summarizes available tables, views, primary keys, and foreign key relationships. Strictly constrained to structural metadata. Does not reveal data rows.
inspect_tableA	Exposes exact column names, types, nullability, primary keys, and foreign key relationships. Strictly constrained to structural layouts. Does not reveal data rows.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Siddharth-coder13/secure_schema_mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server