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
211,928 tools. Last updated 2026-06-19 06:51
"How to perform SELECT queries in PostgreSQL" matching MCP tools:
- Monitor currently running PostgreSQL queries to identify performance bottlenecks and manage database connections effectively.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 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.
- Switches the active PostgreSQL server and database connection. Required before executing queries; specify server from list_servers and optionally select database and schema.MIT
Matching MCP Servers
- 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.Last updated51Apache 2.0
- AlicenseAqualityAmaintenanceMCP server for amazon.in — cheapest in-stock, best-value picks, and price history links.Last updated403231MIT
Matching MCP Connectors
Transform any blog post or article URL into ready-to-post social media content for Twitter/X threads, LinkedIn posts, Instagram captions, Facebook posts, and email newsletters. Pay-per-event: $0.07 for all 5 platforms, $0.03 for single platform.
India Open Government Data (OGD) Platform MCP — data.gov.in
- Run read-only queries on remote databases (MySQL, PostgreSQL, MongoDB) via SSH. Executes SELECT SQL or MongoDB find() commands and returns raw output.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
- 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
- Run SQL statements (SELECT, INSERT, UPDATE, DELETE, DDL) on a project's dedicated PostgreSQL database. Supports parameterized queries with $1, $2 placeholders for safety. Returns rows and count for SELECT, changes for mutations, or changes:0 for DDL.MIT
- Run read-only SQL queries against PostgreSQL databases to retrieve data as formatted tables. Supports SELECT, WITH, EXPLAIN, and SHOW for safe analytical access.MIT
- Establish a connection to a PostgreSQL database using a connection string. Subsequent queries use this connection until changed.MIT
- Execute PostgreSQL SELECT queries to retrieve data, count rows, or check record existence using parameterized queries with optional safety limits.AGPL 3.0
- Execute read-only PostgreSQL database queries to retrieve data securely. Connect using host, port, credentials, and SQL SELECT statements.ISC
- Analyze up to 10 SQL SELECT queries to receive index recommendations, improving query performance by suggesting optimal database indexes.MIT
- Execute SQL queries on PostgreSQL databases with configurable read-only or write permissions to interact with database data.MIT
- Execute SQL queries against a PostgreSQL database and retrieve results as JSON. Use in readonly mode for safe SELECT queries or readwrite for full SQL access (non-production).
- Execute SELECT queries on the RifaExpress PostgreSQL database to retrieve data for analysis and reporting.