Execute a single read-only SQL query (SELECT, WITH, EXPLAIN) on PostgreSQL with write protection, row limits, and bind parameters for safe data retrieval.
MIT
568,621 tools. Updated 2026-09-14 21:37
"postgre" matching MCP tools:
- Manage Fernet encryption keys for stored PostgreSQL secrets: check status, generate or rotate certificates, rekey connection files, and revoke compromised keys.MIT
- Create an index on a PostgreSQL table to improve query performance. Supports concurrent non-blocking builds, unique indexes, and various methods.MIT
- Change or reset PostgreSQL settings with ALTER SYSTEM, preview via dry-run, and revert with automatic undo.MIT
- Simulate an index's effect on a query plan without creating it, showing estimated costs and whether the planner would use it.MIT
- Terminate a PostgreSQL backend by PID to stop blocking or stuck queries. Includes dry-run preview and audit logging to prevent accidental termination.MIT
Matching MCP Servers
- FlicenseAqualityBmaintenanceAn MCP server that enables AI agents to securely interact with PostgreSQL databases with least-privilege scopes, PII masking, and human approval for writes.4-
- AlicenseAqualityAmaintenanceEnables AI assistants to run SQL queries against PostgreSQL databases through the psql CLI, with support for multiple configured databases and enforced read-only guarantees.4MIT
Matching MCP Connectors
Check a Postgres URL shape. Credentials discarded.
Push rows from a dataset, file or Google Sheet into a Postgres, Supabase, Neon or MySQL table.
- Run VACUUM on a PostgreSQL table to reclaim dead tuples and refresh statistics. Supports FULL and ANALYZE options, with dry-run and audit trail.MIT
- Safely drop a PostgreSQL index by capturing its definition for reversible undo, supporting dry-run preview and concurrent dropping to avoid table locks.MIT
- Apply a recorded undo to reverse a previous operation. Use dry_run to preview the inverse tool call before executing.MIT
- Diagnose slow SQL by retrieving its PostgreSQL execution plan, and enable analyze to run the query read-only and report measured timings and buffer usage.MIT
- Return the JSON execution plan for a SQL statement. Optionally run the statement to collect real row counts and timing for performance tuning.MIT
- Lists recorded undo tokens with tool names, inverse actions, and verification status, letting you review pending changes before applying an undo.MIT
- Explore a PostgreSQL database by listing all schemas with their table and view counts, revealing database structure when the layout is unknown.MIT
- Show a SELECT query's execution plan without running it, then use analyze for measured timings to identify performance bottlenecks before executing on large tables.MIT
- Get PostgreSQL database health: cache hit ratio, connections, long-running queries, vacuum backlog, invalid indexes, sequence exhaustion, replication lag. Unreadable values are marked unavailable.MIT
- Discover all available MCP tools and their parameters without a database connection. Returns a JSON array of tool names, descriptions, and input schemas.MIT
- Lists configured PostgreSQL database environments, returning names and non-secret connection details to use as the env argument for other tools. Read-only.MIT
- Generate the OAuth authorization URL users open to connect a WHOOP account; after approval, pass the returned code to whoop_connect.MIT
- Analyze database health to detect issues like invalid indexes, connection overuse, vacuum needs, and replication lag. Run specific checks or all at once.MIT
- Detect database health issues like invalid indexes, connection problems, vacuum risks, sequence limits, replication lag, buffer cache inefficiencies, and invalid constraints. Run specific checks or all.MIT
- Pinpoint the slowest PostgreSQL query and get cited causes plus concrete actions from pg_stat_statements metrics and optional EXPLAIN plans.MIT