PostgreSQL

Provides direct PostgreSQL database access with schema discovery, table exploration, DDL retrieval, data sampling, and SQL execution capabilities with configurable row limits and automatic query protection.

This PostgreSQL MCP server by Blackklegend provides direct database access and management capabilities through the pg library and Model Context Protocol SDK. Built with TypeScript and featuring five core tools including schema listing, table discovery, DDL retrieval, data sampling, and arbitrary SQL execution with configurable row limits, it connects to PostgreSQL databases using standard environment variables or hardcoded defaults and automatically applies LIMIT clauses to prevent runaway queries. The implementation includes comprehensive error handling for SQL operations and uses the information_schema for metadata discovery, making it valuable for database administrators, developers, and AI assistants who need to explore database structures, analyze table contents, and execute ad-hoc queries against PostgreSQL databases in development or production environments.