Skip to main content
Glama
680,081 tools. Updated 2026-10-20 07:53

"How to perform SELECT queries in PostgreSQL" matching MCP tools:

  • Run SQL queries with role-based permissions, enforcing read, write, and delete restrictions across PostgreSQL, MySQL, and SQLite databases.
    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
  • Execute read-only SQL SELECT queries on a PostgreSQL database. Supports CTEs and EXPLAIN, with configurable row limit and timeout.
    MIT

Matching MCP Servers

  • A
    license
    Not graded
    quality
    D
    maintenance
    A minimal MCP server with get_weather and create_ticket tools, used for testing MCP servers across protocol, unit, eval, transport, and auth layers.
    MIT
  • A
    license
    B
    quality
    D
    maintenance
    An AI recipe recommendation server based on the MCP protocol, providing functions such as recipe query, classification filtering, intelligent dietary planning, and daily menu recommendation.
    5
    1
    Apache 2.0

Matching MCP Connectors

  • Execute SQL SELECT queries on MySQL, Oracle, GaussDB, and DM8 databases with configurable row limits and database selection.
    MIT
  • List installed and available PostgreSQL extensions with their versions and descriptions to verify extension availability before writing dependent queries.
    MIT
  • Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN) with auto-appended LIMIT to safely inspect MySQL databases.
    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 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
  • Run EXPLAIN ANALYZE on SELECT queries to inspect execution plans, timing, and buffers, revealing bottlenecks and missing index opportunities.
    MIT
  • Execute SELECT queries on SQL Server databases with automatic pagination to retrieve data while enforcing safety limits and rejecting non-SELECT operations.
    MIT
  • Establish a persistent connection to a PostgreSQL database using a connection string, enabling subsequent queries until changed or disconnected. Only permitted hosts are allowed.
    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
  • Identifies and analyzes slow database queries, showing execution times and optimization recommendations. Works with PostgreSQL and MySQL.
    MIT