Connection check
local install
ainative-postgres-mcp
Zero-config Postgres MCP with auto-provisioning — drop-in for server-postgres.
Tools
5
GitHub stars
—
Installs / wk
157
Licence
—
Transport
stdio
Last checked
never
Tools & capabilities
5 toolsRead from the published package source — this server runs locally, so there is no endpoint to query. Names are taken from the code, not observed at runtime, and descriptions are often absent.
create_table
from source
Create a new table in the database using a SQL CREATE TABLE statement. Supports all PostgreSQL column types including pgvector vector columns. Create a new table in the database using a SQL CREATE TABLE statement. Supports all PostgreSQL column types including pgvector vector columns.
describe_table
from source
Get the full schema of a table including columns (name, type, nullable, default), constraints (primary key, foreign key, unique), and indexes. Supports schema.table format. Get the full schema of a table including columns (name, type, nullable, default), constraints (primary key, foreign key, unique), and indexes. Supports schema.table format.
insert
from source
Insert one or more rows into a table. Rows are provided as an array of objects where keys are column names. Returns the inserted rows. Insert one or more rows into a table. Rows are provided as an array of objects where keys are column names. Returns the inserted rows.
list_tables
from source
List all tables in the connected PostgreSQL database, including schema, table name, and type (BASE TABLE or VIEW). List all tables in the connected PostgreSQL database, including schema, table name, and type (BASE TABLE or VIEW).
query
from source