A simplified PostgreSQL MCP server
Wellknown found it in public sources; nobody has proven control of it yet. Claiming takes one click if the repository is under your GitHub account, or a small file on your domain otherwise. Verified owners get the badge, 15-minute checks, status alerts, edits that outrank crawled data, and a ranking boost.
Agents can do it too: POST https://wellknown.network/api/v1/claims with {"agent":"postgresql-server-mcp","method":"well_known_file"} — machine-readable steps at claim.json, guide at /docs/claim.
Everything here was measured by our prober or read from a registry. Nothing is self-reported.
Attributed to the source that supplied each field. Treated as claims, not facts.
# Simplified PostgreSQL MCP Server [中文文档](README_zh.md) A lightweight PostgreSQL Model Context Protocol (MCP) server, designed to provide basic database interaction and query analysis capabilities. ## Tools - **query_sql** - **Description**: Execute read-only SQL queries (SELECT). - **Arguments**: `sql` (string) - The SELECT query to execute. - **Returns**: Query results in JSON format. - **execute_sql** - **Description**: Execute modification SQL statements (DML) such as INSERT, UPDATE, DELETE. - **Arguments**: `sql` (string) - The DML statement to execute. - **Returns**: Execution status message (e.g., number of rows affected). - **run_ddl** - **Description**: Execute database structure definition statements (DDL) such as CREATE, DROP, ALTER, TRUNCATE. - **Arguments**: `sql` (string) - The DDL statement to execute. - **Returns**: Execution status message. - **list_tables** - **Description**: List tables in the database. - **Arguments**: `schema` (string, default "public") - The schema name to query. - **Returns**: JSON list containing table names and types. - **describe_table** - **Description**: Get detailed structure information of a table. - **Arguments**: - `table_name` (string) - The name of the table. - `schema` (string, default "public") - The schema name. - **Returns**: JSON list containing column names, data types, nullability, default values, etc. - **explain_query** - **Description**: Analyze SQL query plans, with support for hypothetical indexes. - **Arguments**: - `sql` (string) - The SQL statement to analyze. - `analyze` (boolean, default false) - Whether to actually execute the query (EXPLAIN ANALYZE). - `hypothetical_indexes` (list[string], optional) - List of hypothetical index definitions (requires `hypopg` extension). - **Returns**: Query plan in JSON format. ## Quick…
Mapped onto the structured taxonomy from declared text and observed tool names. Confidence shown for derived entries.
Every source is kept verbatim. Field changes are logged as events.