Schema | Schema Sentinel

Schema Sentinel

Describes the environment variables required to run the server.

Name	Required	Description
`SCHEMA_SENTINEL_DB_URL`	Yes	Postgres connection string for a read-only role
`SCHEMA_SENTINEL_REPO_PATH`	Yes	Path to the git repository paired with the database
`SCHEMA_SENTINEL_MIGRATIONS_PATH`	Yes	Path to the migrations directory

Features and capabilities supported by this server

Capability	Details
`tools`	{ "listChanged": false }
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`experimental`	{}

Functions exposed to the LLM to take actions

Name	Description
get_schema_overviewB	Tables, columns, PKs, FKs for the connected database.
find_missing_indexesA	Flags FK columns with no covering index.
find_circular_foreign_keysA	Catches FK cycles across tables.
find_table_complexityA	Structural complexity per table: column count, FK fan-in/out, circular-FK involvement.
generate_erdB	Mermaid erDiagram text for the connected schema.
check_migration_riskA	Statically parses a single migration .sql file and flags risky patterns. Never executes it.
find_schema_churnB	Git-history churn per table: how often (and how recently) each table's migrations changed.
generate_reportC	Rolls every tool above into one combined health report.

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/ramoniglesias98/schema-sentinel'

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