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

Read-only MCP server for PostgreSQL, enabling schema discovery, table metadata, and safe SELECT queries via READ ONLY transactions.

A production-oriented MCP server for PostgreSQL that exposes database operations like query execution, schema introspection, and table metadata to MCP clients such as Claude Desktop and VS Code.

A secure MCP server that lets AI assistants directly interact with PostgreSQL databases via tools like create_table, list_tables, and execute_sql, plus a web configurator for managing connections.

Enables AI assistants to safely interact with PostgreSQL databases, perform queries, inspect schemas, and analyze query performance.

A production-ready MCP server that connects AI assistants to any PostgreSQL database with 25 tools and role-based access control.

A general-purpose PostgreSQL MCP server with full read-write SQL access, atomic multi-statement transactions, and schema inspection. Works with any PostgreSQL instance — local, Supabase, AWS RDS, or self-hosted — and connects to Claude, Cursor, Windsurf, or any MCP-compatible AI client.

Provides AI-driven PostgreSQL database management with secure OAuth 2.1 authentication, enabling users to administer, monitor, and query databases with support for extensions like pgvector, PostGIS, and pg_cron.

Enables AI agents to interact with PostgreSQL databases over HTTP/JSON-RPC, supporting SQL queries, schema introspection, table/index analysis, EXPLAIN query planning, role and privilege inspection, and database monitoring.

Enables AI assistants to perform PostgreSQL database operations, monitoring, and management via natural language, covering performance analysis, bloat detection, lock/deadlock monitoring, autovacuum and schema inspection with read-only production-safe queries.

Enables AI assistants to perform read-only PostgreSQL database operations, monitoring, and management through natural language queries, including performance analysis, bloat detection, lock/deadlock monitoring, autovacuum inspection, and schema discovery across PostgreSQL 12–18.

Enables Claude Desktop to connect to PostgreSQL databases, allowing users to query, explore schemas, and analyze data using plain English without writing SQL.

A Model Context Protocol server that provides read-only access to PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

Enables Claude Desktop to interact with PostgreSQL databases through natural language for schema exploration, data analysis, and query execution. Users can search schemas, describe tables, and perform read or write operations without needing to write manual SQL.

Full-featured MCP server that exposes 36 tools for interacting with PostgreSQL databases, covering schema introspection, query execution, data exploration, performance monitoring, security auditing, and maintenance.

Enables comprehensive PostgreSQL database monitoring, analysis, and management through natural language queries. Provides performance insights, bloat analysis, vacuum monitoring, and intelligent maintenance recommendations across PostgreSQL versions 12-17.

A Model Context Protocol server that enables interaction with PostgreSQL databases for analyzing setups, debugging issues, managing schemas, migrating data, and monitoring performance.

A secure PostgreSQL MCP server with built-in SSH tunneling that enables AI assistants to connect to databases through bastion hosts automatically, supporting both STDIO and Streamable HTTP transports.

A Model Context Protocol server that enables powerful PostgreSQL database management capabilities including analysis, schema management, data migration, and monitoring through natural language interactions.

Facilitates management and optimization of PostgreSQL databases, offering analysis, setup guidance, and debugging, while ensuring secure and efficient database operations.

Enables natural language interaction with PostgreSQL databases through Amazon Q for querying data, listing tables, and describing schemas. It provides secure, read-only access with automatic row limits to ensure efficient database exploration.