Run SQL queries to analyze, modify, or troubleshoot Heroku PostgreSQL databases. Execute commands or file-based queries with credential management for direct database access.
Apache 2.0
207,082 tools. Last updated 2026-06-17 20:13
"Connecting to PostgreSQL database, retrieving table schema, and executing SQL queries" matching MCP tools:
- Switches the active PostgreSQL server and database connection. Required before executing queries; specify server from list_servers and optionally select database and schema.MIT
- Execute SQL queries on PostgreSQL databases with configurable read-only or write permissions to interact with database data.MIT
- Generate schema-aware query suggestions with ready-to-run SQL to help explore unfamiliar databases and find useful queries.MIT
- Validate SELECT SQL statements against your live database to check syntax, column references, and join resolution without executing any rows.MIT
- Execute SQL queries (SELECT, INSERT, UPDATE, DELETE) against a database connection. Supports parameterized queries to prevent SQL injection.Apache 2.0
Matching MCP Servers
- Alicense-qualityDmaintenanceMCP server for connecting to databases (PostgreSQL, MySQL, SQL Server, Redis) enabling SQL queries, table exploration, and Redis key-value operations.Last updated1MIT
- Alicense-qualityDmaintenanceA Model Context Protocol server that provides read-only access to PostgreSQL databases with enhanced multi-schema support, allowing LLMs to inspect database schemas across multiple namespaces and execute read-only queries while maintaining schema isolation.Last updated1443MIT
Matching MCP Connectors
MCP server (stdio): validate JSON against JSON Schema (draft-07 / 2020-12) via the AgentForge API
Cloudflare Workers MCP server: api-schema-drift-detector
- Describe database table columns: list column names, data types, primary keys, and foreign key relationships. Use before writing queries to understand table structure.Apache 2.0
- Describe database table columns, primary key, foreign keys, and indexes by querying the live catalog. Use before writing SQL joins or dashboard queries to verify column names and types.MIT
- Generate SQL migration scripts by comparing database schemas. Compare live databases or a database against target DDL to create ALTER statements for schema updates.MIT
- Load back-end generated starter queries for a schema or database derived from actual storage units, helping you explore unfamiliar databases.Apache 2.0
- Reformat SQL statements with consistent indentation and keyword casing, and retrieve query statistics without connecting to a database.MIT
- Lists all tables and views in the live database catalog. Use it to discover table names before writing SQL queries or exploring an unfamiliar schema.MIT
- Retrieve counts, labels, edge types, and schema of your graph database to understand its state before writing queries or after mutations.Apache 2.0
- Inspect table metadata including columns, row count, byte count, project, and organization to verify schema before writing SQL queries.MIT
- Execute SQL SELECT queries on a Bauplan data catalog table and save results to a CSV file, providing the output file path.MIT
- Find SQL string literals in Go source code with their enclosing function and file location. Optionally filter by SQL keyword or table name. Ideal for auditing database interactions and reviewing query performance.MIT
- Insert data into watsonx.data by executing INSERT SQL queries on a specified engine, with required catalog and schema names.Apache 2.0
- List all tables in a watsonx.data schema by providing catalog, schema, and engine IDs. Returns table names and total count.Apache 2.0
- Retrieve the database schema for Logfire telemetry data, including table structures and column types, to construct efficient SQL queries.MIT
- Returns a direct sign-on link to phpMyAdmin for visual database management, including SQL queries, imports, exports, and table operations.MIT