MCP Servers / database / Postgres MCP Server

Postgres MCP Server

none★ 1database

Provides secure database access to PostgreSQL using the Kysely ORM.

Install

How to run this server

[ { "cmd": "npx postgres-mcp-server", "imports": [] } ]

server path: postgres-mcp-server

Tools

What this server exposes

query

Execute SQL queries with pagination support

describe_table

Get table structure and column details

list_tables

List all tables in a schema

list_schemas

List all schemas in the database

get_constraints

Get table constraints (PK, FK, etc.)

list_indexes

List indexes for a table or schema

list_views

List views in a schema

list_functions

List functions and procedures

explain_query

Get query execution plan

get_table_stats

Get table size and statistics

Configuration

Environment & auth

authnone

Resources