PostgreSQL MCP — query databases, inspect schemas, explain queries.
Connects MCP-compatible agents and IDEs to databases through prebuilt or custom tools.
Key Features: Custom YAML-defined tools Multi-database source support Connects AI clients to MySQL for schema inspection and SQL queries, with opt-in writes and configurable database access controls.
Key Features: Read-only SQL access by default Schema and column metadata resource Opt-in insert, update, and delete permissions Connects MCP clients to MySQL for SQL execution, schema inspection, and small table samples.
Key Features: SQL execution with error handling Schema metadata inspection Connects MCP-compatible clients to PostgreSQL for querying, schema inspection, performance analysis, and optional writes.
Key Features: Read-only SQL querying by default Optional INSERT, UPDATE, and DELETE execution Schema, view, function, and table inspection MCP server enabling SQL read/write and schema insight operations on Snowflake databases.
Key Features: Read SQL queries via read_query tool Write SQL queries and create tables with --allow-write List databases, schemas, and tables MCP server for SQL syntax validation, linting, dialect conversion, and query analysis using SQLGlot.
Key Features: SQL syntax validation and linting SQL dialect transpilation (e.g., MySQL to PostgreSQL) Extraction of table and CTE references MCP server for Airtable with schema inspection and full read/write record and table management.
Key Features: List and describe Airtable bases and tables with detail levels Read, search, create, update, and delete records Create and update tables and fields with metadata MySQL MCP server with CRUD, anomaly analysis, role-based permissions, and extensible custom tools support.
Key Features: Supports all MCP transfer modes: STDIO, SSE, Streamable HTTP Role-based permissions: readonly, writer, admin Multiple SQL statements execution separated by semicolons MCP server for Postgres with tools for index tuning, query plans, health checks, and safe SQL execution.
Key Features: Database health checks including index, vacuum, replication, and cache analysis Industrial-strength index tuning algorithms EXPLAIN plan validation and hypothetical index simulation Query and inspect multiple database systems through one MCP interface with SQL, schema discovery, and database selection tools.
Key Features: Multi-database connection support SQL execution with markdown or JSON results Schema and table inspection Java MCP server providing generic JDBC connectivity to databases with schema, table, and query support.
Key Features: Retrieve database schemas and tables Describe detailed table metadata Filter tables by name substring