get_schema
List schemas, tables, columns, indexes, relationships, and optional Mermaid ERDs
How to use it
get_schema is exposed by the DBeast MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the get_schema tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install DBeast
pip install -e .Other tools in DBeast (20)
Preview write-query impact, risk level, affected rows, and rollback context without executing
Parse and inspect query structure, warnings, and optimization hints
Review PostgreSQL configuration and tuning opportunities
Connect to PostgreSQL, check current status, or discover local databases
Analyze null rates, cardinality, value distributions, and outliers
Review cache hit rates, connections, transaction age, table health, and overall health signals
Map object dependencies before renaming, dropping, or changing database objects
Close the current database connection
Find duplicate rows across selected key columns
Run read-only SELECT queries with automatic row-limit injection
Retrieve logged MCP tool calls for a given date
Verify connectivity, pool health, PostgreSQL version, and extensions
List available audit log files
Review vacuum status, dead tuples, analyze timestamps, and index health
Inspect partition health, row distribution, and missing partition risks
Recommend indexes and rewrites for a given query
Report slow or expensive queries from PostgreSQL statistics
Inspect replication lag, WAL sender/receiver state, and replication slots
Inspect roles, privileges, superuser accounts, and public schema exposure
Detect likely PII or secrets by column names and schema patterns