connect
Connect to PostgreSQL, check current status, or discover local databases
How to use it
Project documentation lists connect for the DBeast MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.
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
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
List schemas, tables, columns, indexes, relationships, and optional Mermaid ERDs
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