Retrieve the archive database schema, including table and column names. Understand available data for crafting SQL queries.
Apache 2.0
675,423 tools. Updated 2026-10-19 05:13
"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
sql-to-mcpofficial
AlicenseNot gradedqualityCmaintenanceEnables AI assistants to query PostgreSQL, MySQL, SQL Server, Oracle, and MongoDB databases through MCP with read-only, audited access.2AGPL 3.0- AlicenseNot gradedqualityCmaintenanceMCP 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
Matching MCP Connectors
https CSV to headers and rows. x402 $0.005 USDC, Base. As is, no warranty.
Push rows from a dataset, file or Google Sheet into a Postgres, Supabase, Neon or MySQL table.
- 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
- Creates a native database schema for a project from a template. Supports PostgreSQL, MySQL, and SQLite; returns contents without executing or saving SQL.MIT
- Execute parameterized SQL statements on a PostgreSQL database, returning rows and row counts.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.-
- Run SQL queries on DuckDB or MotherDuck databases. Unqualified table names resolve automatically to the current database and schema.MITDestructive
- 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
- 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
- Lists every catalog, schema, and table you are allowed to query; call it first to ground table discovery and SQL writing.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
- Insert data into watsonx.data by executing INSERT SQL queries on a specified engine, with required catalog and schema names.Apache 2.0