DBeast

Unclaimed

by snss10

Expert-level PostgreSQL database analysis MCP server for AI assistants.

ai-toolsasyncpgclaudecursordatabasedbamcpmodel-context-protocolpostgresqlpython

Install

$pip install -e .

Unclaimed listing

Is this your MCP server?

This listing was auto-indexed from the public record. Claim it to edit the page, set compatibility and unlock growth tools. Takes under two minutes.

Claim this server

Tools (21)

analyze_impact

Preview write-query impact, risk level, affected rows, and rollback context without executing

analyze_query

Parse and inspect query structure, warnings, and optimization hints

configuration_review

Review PostgreSQL configuration and tuning opportunities

connect

Connect to PostgreSQL, check current status, or discover local databases

data_quality_report

Analyze null rates, cardinality, value distributions, and outliers

database_health

Review cache hit rates, connections, transaction age, table health, and overall health signals

dependency_analysis

Map object dependencies before renaming, dropping, or changing database objects

disconnect

Close the current database connection

duplicate_detection

Find duplicate rows across selected key columns

execute_query

Run read-only SELECT queries with automatic row-limit injection

get_audit_logs

Retrieve logged MCP tool calls for a given date

get_schema

List schemas, tables, columns, indexes, relationships, and optional Mermaid ERDs

health_check

Verify connectivity, pool health, PostgreSQL version, and extensions

list_audit_files

List available audit log files

maintenance_analysis

Review vacuum status, dead tuples, analyze timestamps, and index health

partition_analysis

Inspect partition health, row distribution, and missing partition risks

query_optimizer

Recommend indexes and rewrites for a given query

query_performance

Report slow or expensive queries from PostgreSQL statistics

replication_status

Inspect replication lag, WAL sender/receiver state, and replication slots

security_audit

Inspect roles, privileges, superuser accounts, and public schema exposure

sensitive_data_scan

Detect likely PII or secrets by column names and schema patterns