Run SQL queries with role-based permissions, enforcing read, write, and delete restrictions across PostgreSQL, MySQL, and SQLite databases.
MIT
465,816 tools. Updated 2026-08-19 06:53
"How to perform SELECT queries in PostgreSQL" matching MCP tools:
- Analyze slow PostgreSQL queries by running EXPLAIN ANALYZE on top SELECT statements, detecting performance issues like sequential scans and missing indexes.MIT
- 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
- Monitor currently running PostgreSQL queries to identify performance bottlenecks and manage database connections effectively.MIT
- Perform read-only SQL SELECT queries to fetch, count, aggregate, and join data from tables. Supports configurable limits, timeout, and output formats.MIT
- Execute SurrealQL queries to interact with SurrealDB databases for complex operations like SELECT with JOINs, schema definitions, transactions, and graph traversals.MIT
Matching MCP Servers
- Alicense-qualityCmaintenanceA minimal MCP server with get_weather and create_ticket tools, used for testing MCP servers across protocol, unit, eval, transport, and auth layers.MIT
- AlicenseBqualityDmaintenanceAn AI recipe recommendation server based on the MCP protocol, providing functions such as recipe query, classification filtering, intelligent dietary planning, and daily menu recommendation.51Apache 2.0
Matching MCP Connectors
ifsc-in MCP — Indian bank branch IFSC code lookup via Razorpay's open
India Open Government Data (OGD) Platform MCP — data.gov.in
- Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN) with auto-appended LIMIT to safely inspect MySQL databases.MIT
- Execute read-only SQL SELECT queries on a PostgreSQL database. Supports CTEs and EXPLAIN, with configurable row limit and timeout.MIT
- Execute SQL SELECT queries on MySQL, Oracle, GaussDB, and DM8 databases with configurable row limits and database selection.MIT
- Execute SQL SELECT queries to retrieve data from PostgreSQL databases. This read-only tool returns query results with rows, columns, and metadata for database analysis.MIT
- Execute read-only SELECT queries to explore, debug, or validate data in the Avanti Fellows PostgreSQL database.
- Execute read-only SQL queries like SELECT, EXPLAIN, and SHOW on PostgreSQL, with automatic validation to block any write or DDL operations.MIT
- Execute read-only SELECT queries on MySQL/MariaDB databases. Mutating SQL is rejected; locking queries require confirmation.MIT
- Check which PostgreSQL extensions are installed, including version, schema, and description, before writing queries that depend on them.MIT
- Identify and analyze slow PostgreSQL queries using pg_stat_statements to optimize database performance by revealing top time-consuming queries with execution metrics.Apache 2.0
- Switches the active PostgreSQL server and database connection. Required before executing queries; specify server from list_servers and optionally select database and schema.MIT
- Identifies and analyzes slow database queries, showing execution times and optimization recommendations. Works with PostgreSQL and MySQL.MIT
- Detect idle-in-transaction sessions, lock contention, and long-running queries on PostgreSQL to troubleshoot blocking and connection pool issues.MIT
- Execute read-only SQL queries on a chosen MySQL or PostgreSQL database, with optional parameterized values and support for statements like SELECT, SHOW, DESCRIBE, and EXPLAIN.MIT
- Execute read-only SELECT queries on PostgreSQL with optional row limits, parameter binding, and multi-statement support for non-parameterized SQL.MIT