MCPVault

query

MCP tool from Postgres MCP by JaviMaligno

Execute read-only SQL queries against the database

How to use it

query is exposed by the Postgres MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the query tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install Postgres MCP

$npx @javiagui/postgresql-mcp
FULL POSTGRES MCP LISTING

Other tools in Postgres MCP (14)

describe_table

Get table structure (columns, types, constraints)

describe_view

Get view definition and columns

execute

Execute write operations (INSERT/UPDATE/DELETE) when enabled

explain_query

Get EXPLAIN plan for query optimization

get_database_info

Get database version and connection info

list_constraints

List constraints (PK, FK, UNIQUE, CHECK)

list_databases

List the configured connections by alias, with host, database, write permission and which is the default. Never returns credentials.

list_functions

List functions and procedures

list_indexes

List indexes for a table

list_schemas

List all schemas in the database

list_tables

List tables in a specific schema

list_views

List views in a schema

search_columns

Search for columns by name across all tables

table_stats

Get table statistics (row count, size, bloat)