Retrieve the archive database schema, including table and column names. Understand available data for crafting SQL queries.
Apache 2.0
463,257 tools. Updated 2026-08-18 16:56
"Connecting to PostgreSQL database, retrieving table schema, and executing SQL queries" matching MCP tools:
- 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
- Validate SQL query syntax without executing it. Uses an EXPLAIN-like check to confirm the query is valid for the target database. Works with engines like PostgreSQL.MIT
- Execute SQL queries via Superset's SQL Lab to retrieve data. Provide database ID and SQL; set schema, catalog, or template params as needed.MIT
- Switches the active PostgreSQL server and database connection. Required before executing queries; specify server from list_servers and optionally select database and schema.MIT
- Save SQL text as a reusable query in SQL Lab, associated with a database and optional schema.MIT
Matching MCP Servers
- Alicense-qualityAmaintenanceMCP server that connects to SQL databases (SQLite, PostgreSQL, MSSQL, MySQL) and provides tools to run read-only queries, list schemas/tables, and manage connections via stdio transport.Apache 2.0
- Alicense-qualityCmaintenanceMCP server that translates natural-language questions into SQL, validates every query structurally, and executes approved read-only queries against a SQLite database, returning results and rejections.MIT
Matching MCP Connectors
MCP server (stdio): validate JSON against JSON Schema (draft-07 / 2020-12) via the AgentForge API
Executes SQL in a real ephemeral database: rows, typed errors with suggestions, plans, diffs.
- Execute a read-only SQL query against a stand's PostgreSQL database by providing the stand name and schema-qualified query.MIT
- Estimate SQL execution cost via EXPLAIN to preview resource usage and avoid expensive queries. Works with PostgreSQL and other supporting engines.MIT
- Execute SQL SELECT queries to retrieve data from Snowflake databases using fully qualified table names, including database, schema, and table details for accurate results.MIT
- Execute SQL queries on PostgreSQL databases with configurable read-only or write permissions to interact with database data.MIT
- Analyzes SQL queries, table schemas, migrations, and index performance to identify issues and optimize database behavior.
- Generate schema-aware query suggestions with ready-to-run SQL to help explore unfamiliar databases and find useful queries.MIT
- 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
- Validate SELECT SQL statements against your live database to check syntax, column references, and join resolution without executing any rows.MIT
- Describe database table columns to understand structure, identify primary and foreign keys before writing queries.Apache 2.0
- 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
- Execute SQL queries to retrieve, insert, update, or delete data from a connected database. Supports parameterized inputs for secure querying.Apache 2.0
- 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