"A guide for executing queries in a GCP PostgreSQL database" matching MCP tools:

• switch_server_dbA

  postgres-mcp-server

  Switches the active PostgreSQL server and database connection. Required before executing queries; specify server from list_servers and optionally select database and schema.

  MIT

• whodb_suggestionsA

  whodb-cli

  Load starter queries generated from your database schema to quickly orient yourself in unfamiliar data.

  Apache 2.0

• create_cloudflow_connectionA

  DoiT MCP Server

  Create a new CloudFlow connection to link a GCP or AWS account for cloud automation. Requires either GCP or AWS configuration.

  MIT

• pg_upgradeA

  Heroku MCP server

  Upgrade PostgreSQL database versions safely for Heroku apps. Plan migration paths, verify compatibility, and execute controlled upgrades with confirmation protection to ensure a secure transition.

  Apache 2.0

• pg_psA

  Heroku MCP server

  Monitor active database queries and processes on Heroku apps to identify long-running queries, track progress, debug performance issues, and view resource usage in real-time.

  Apache 2.0

• db_connectA

  Berth

  Establish database connections for PostgreSQL, MySQL, or SQLite to enable querying, schema management, and migration operations within the Berth MCP server.

  MIT

• fasttransfer_preview_transferA

  arpeio-mcp

  Build and preview a database-to-database transfer command without executing. Shows the masked CLI command and auto-suggests parallelism method based on source type.

  MIT

• db_backupA

  Berth

  Create database backups for PostgreSQL, MySQL, and SQLite using native dump tools, with output paths sandboxed to a designated backup directory.

  MIT

• hosting_getPhpMyAdminLinkV1A

  hostinger-api-mcp

  Returns a direct sign-on link to phpMyAdmin, enabling visual database management for SQL queries, imports, exports, and table operations.

  MIT

• pg_psqlA

  Heroku MCP server

  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

• pg_infoA

  Heroku MCP server

  Analyze Heroku PostgreSQL database configurations, monitor performance metrics, and assess health and resource usage. Obtain detailed insights into database operations for informed decision-making.

  Apache 2.0

• list_extensionsA

  Aliyun RDS Supabase MCP Server

  List all installed PostgreSQL extensions in your database to view available features and capabilities.

  MIT

• executePostgreSQLSqlQueryA

  WayStation MCP Server

  Execute read-only SQL queries against your PostgreSQL database and retrieve the results.

  MIT

• create-serviceA

  bult-mcp-server

  Create daemon apps from GitHub or Docker, and database services (PostgreSQL, Redis, MySQL, MongoDB) for Bult projects.

  MIT

• pg_inspect_schemaA

  indiekit-mcp

  Inspect PostgreSQL database schema to retrieve tables, columns, types, indexes, constraints, enums, and extensions.

  MIT

• fetchPostgreSQLSchemaB

  WayStation MCP Server

  Fetch the schema of a connected PostgreSQL database, listing all tables and columns.

  MIT

• db_active_queriesC

  Berth

  Monitor currently running PostgreSQL queries to identify performance bottlenecks and manage database connections effectively.

  MIT

• search_best_practicesA

  mcp-canon

  Retrieve best practices for code patterns and recommendations by searching across all guides or within a specific guide using natural language queries.

  MIT

• pg_queryA

  @yawlabs/postgres-mcp

  Run SQL queries against a PostgreSQL database with read-only by default. Supports parameterized queries to prevent SQL injection and truncates large results.

  MIT

• get_pg_stat_statements_top_queriesA

  MCP PostgreSQL Operations

  Analyze top PostgreSQL queries by execution time to identify performance bottlenecks and optimize database performance using pg_stat_statements statistics.

  MIT