MCP Servers for PostgreSQL

PostgreSQL is an advanced open source relational database management system that offers robustness, scalability, and performance.

View all MCP Servers

  • Why this server?

    Enables direct interaction with Heroku PostgreSQL databases, including executing SQL queries, viewing database information, managing active queries, identifying resource-intensive operations, handling credentials, managing backups, and performing database upgrades.

    A
    security
    A
    license
    A
    quality
    Let's your agent access the heroku platform
    33
    38
    12
    TypeScript
    Apache 2.0
    • Linux
    • Apple
  • Why this server?

    Enables interaction with Aiven for PostgreSQL services, allowing access to database resources hosted on the Aiven platform.

    A
    security
    A
    license
    A
    quality
    A Model Context Protocol server that provides access to Aiven services (PostgreSQL, Kafka, ClickHouse, Valkey, OpenSearch), enabling LLMs to build full stack solutions by interacting with these services.
    3
    5
    Python
    Apache 2.0
    • Apple
  • Why this server?

    Connects to PostgreSQL databases, allowing for schema exploration, table descriptions, and SQL query execution.

    A
    security
    A
    license
    A
    quality
    Provides SQLAlchemy (via pyodbc) connectivity to any Database Management System (DBMS) that's accessible via SQLAlchemy.
    11
    7
    Python
    Apache 2.0
    • Apple
    • Linux
  • Why this server?

    Provides tools for database health monitoring, index tuning, schema intelligence, query optimization, and protected SQL execution in PostgreSQL databases. Includes workload analysis, index recommendations, slow query identification, and database health checks.

    A
    security
    A
    license
    A
    quality
    Postgres Pro is an open source Model Context Protocol (MCP) server built to support you and your AI agents throughout the entire development process—from initial coding, through testing and deployment, and to production tuning and maintenance.
    9
    67
    Python
    MIT License
    • Apple
    • Linux
  • Why this server?

    Enables access to PostgreSQL service configuration options in NixOS, allowing AI assistants to search and retrieve information about PostgreSQL service settings.

    A
    security
    A
    license
    A
    quality
    MCP-NixOS is a Model Context Protocol server that provides real-time, accurate information about NixOS packages, options, Home Manager, and nix-darwin configurations, preventing AI assistants from hallucinating about NixOS resources and enabling them to deliver factual system configuration guidance.
    13
    44
    Python
    MIT License
    • Linux
    • Apple
  • Why this server?

    Provides tools for executing PostgreSQL queries against Supabase databases with risk assessment, parsing, and validation. Includes automatic migration versioning for database-altering operations.

    A
    security
    A
    license
    A
    quality
    This server enables interaction with Supabase PostgreSQL databases through the MCP protocol, allowing seamless integration with Cursor and Windsurf IDEs for secure and validated database management.
    11
    607
    Python
    Apache 2.0
    • Apple
    • Linux
  • Why this server?

    Provides integration with PostgreSQL databases for storing prompts, with export/import functionality and synchronization between file storage and database

    A
    security
    A
    license
    A
    quality
    Enables creation, management, and templating of prompts through a simplified SOLID architecture, allowing users to organize prompts by category and fill in templates at runtime.
    6
    1,385
    6
    TypeScript
    MIT License
    • Apple
    • Linux
  • Why this server?

    Allows importing data from CSV and Excel files into PostgreSQL databases

    A
    security
    A
    license
    A
    quality
    A Claude integration that enables updating various database types (PostgreSQL, MySQL, MongoDB, SQLite) from CSV and Excel files through natural language commands.
    2
    JavaScript
    Apache 2.0
    • Apple
  • Why this server?

    Allows connecting to and interacting with PostgreSQL databases, including listing tables, viewing triggers, listing functions, executing SQL queries, and exporting schema and data.

    A
    security
    A
    license
    A
    quality
    A powerful Model Context Protocol (MCP) tool for exploring and managing different types of databases including PostgreSQL, MySQL, and Firestore.
    9
    3
    TypeScript
    MIT License
  • Why this server?

    Provides PostgreSQL database management capabilities including analysis, setup instructions, and debugging for PostgreSQL database instances

    A
    security
    A
    license
    A
    quality
    Facilitates management and optimization of PostgreSQL databases, offering analysis, setup guidance, and debugging, while ensuring secure and efficient database operations.
    3
    4
    TypeScript
    AGPL 3.0
    • Linux
    • Apple
  • Why this server?

    Connects to PostgreSQL databases, automatically generates APIs from table schemas, and provides secure access to data with support for complex queries.

    -
    security
    A
    license
    -
    quality
    MCP-Server from your Database optimized for LLMs and AI-Agents. Supports PostgreSQL, MySQL, ClickHouse, Snowflake, MSSQL, BigQuery, Oracle Database, SQLite, ElasticSearch, DuckDB
    237
    Go
    Apache 2.0
    • Linux
  • Why this server?

    Enables interaction with PostgreSQL databases, providing tools for executing queries, managing database connections, listing tables, and describing table structures with support for prepared statements and comprehensive error handling.

    A
    security
    F
    license
    A
    quality
    Enables AI models to interact with PostgreSQL databases through a standardized interface, supporting operations like queries, table manipulation, and schema inspection.
    5
    JavaScript
  • Why this server?

    Used as the vector database backend for storing and retrieving memories with semantic search capabilities

    -
    security
    A
    license
    -
    quality
    A Model Context Protocol server that provides AI agents with persistent memory capabilities through Mem0, allowing them to store, retrieve, and semantically search memories.
    2
    Python
    MIT License
  • Why this server?

    Provides tools for AI-optimized interaction with PostgreSQL databases, including schema exploration, query execution, and performance analysis. Enables AI to understand and manipulate database structures with schema-aware context.

    -
    security
    A
    license
    -
    quality
    The Multi DB MCP Server is a high-performance implementation of the Database Model Context Protocol designed to revolutionize how AI agents interact with databases. Currently supporting MySQL and PostgreSQL databases.
    97
    Go
    MIT License
    • Linux
    • Apple
  • Why this server?

    Connects directly to PostgreSQL databases for query execution, schema exploration, and data analysis

    -
    security
    A
    license
    -
    quality
    Connects Claude Desktop directly to databases, allowing it to explore database structures, write SQL queries, analyze datasets, and create reports through an API layer with tools for table exploration and query execution.
    137
    Python
    Mozilla Public License 2.0
    • Apple
  • Why this server?

    Provides tools for interacting with PostgreSQL databases, including CRUD operations, schema management (listing databases and tables, describing table structures, creating and altering tables), and executing SQL queries with optional query plan validation and read-only mode protection.

    -
    security
    A
    license
    -
    quality
    what is go-mcp-postgres? go-mcp-postgres is a Model Context Protocol (MCP) server designed for interacting with Postgres databases, allowing for easy CRUD operations and automation without the need for a Node.js or Python environment.
    4
    Go
    MIT License
    • Linux
    • Apple
  • Why this server?

    Provides tools for connecting to and interacting with PostgreSQL databases, supporting data querying, modification, and schema operations

    -
    security
    A
    license
    -
    quality
    MCP to access any database accessible via JDBC such as Postgres, Oracle, mysql, mariadb, sqlite etc.
    88
    Apache 2.0
  • Why this server?

    Provides read-only access to PostgreSQL databases, allowing LLMs to inspect database schemas and execute read-only queries against connected PostgreSQL databases

    -
    security
    A
    license
    -
    quality
    A Model Context Protocol server that provides read-only access to PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
    1
    23,627
    34,289
    JavaScript
    MIT License
  • Why this server?

    Used as the database backend for storing user interactions and tracking data for the AI customer support system.

  • Why this server?

    Integrates with PostgreSQL databases, specifically with the Apache AGE extension that enables graph database capabilities in PostgreSQL. Allows querying, creating, and managing graph data structures.

    -
    security
    A
    license
    -
    quality
    An MCP server that provides natural language interaction with Apache AGE graph databases, allowing users to query, visualize and manipulate graph data in PostgreSQL through Claude AI.
    Python
    MIT License
    • Apple
  • Why this server?

    Allows execution of SQL queries against a PostgreSQL database, access to database schema information, and use of query templates, enabling AI assistants to retrieve and manipulate data in PostgreSQL databases.

    -
    security
    A
    license
    -
    quality
    A template project for building custom MCP servers that enables direct access to PostgreSQL databases, allowing SQL query execution and schema information retrieval through the Model Context Protocol.
    3
    Python
    MIT License
    • Apple
    • Linux
  • Why this server?

    Allows querying PostgreSQL databases, browsing tables, viewing schema information, and running read-only SQL queries with safety checks.

    -
    security
    A
    license
    -
    quality
    Universal database MCP server connecting to MySQL, PostgreSQL, SQLite, DuckDB and etc.
    6
    131
    TypeScript
    MIT License
  • Why this server?

    Provides access to PostgreSQL databases, enabling LLMs to inspect schemas, execute queries, and perform CRUD operations (Create, Read, Update, Delete) on database entries.

    -
    security
    A
    license
    -
    quality
    A Model Context Protocol server providing LLMs read-only access to PostgreSQL databases for inspecting schemas and executing queries.
    23,627
    10
    JavaScript
    MIT License
    • Apple
  • Why this server?

    Enables SQL execution, schema inspection, and database migration management for PostgreSQL databases

    -
    security
    A
    license
    -
    quality
    An MCP server that enables natural language querying of Supabase PostgreSQL databases using Claude 3.7, allowing users to inspect schemas, execute SQL, manage migrations, and convert natural language to SQL queries.
    Python
    MIT License
    • Linux
    • Apple
  • Why this server?

    Planned integration for PostgreSQL database operations, including SQL queries, table operations, and schema management.

    -
    security
    A
    license
    -
    quality
    A Model Context Protocol server that enables LLMs to interact with databases (currently MongoDB) through natural language, supporting operations like querying, inserting, deleting documents, and running aggregation pipelines.
    TypeScript
    MIT License
    • Apple
  • Why this server?

    Enables connection to PostgreSQL databases, with support for querying, schema exploration, and data operations through environment variable configuration.

    -
    security
    A
    license
    -
    quality
    A Model Context Protocol (MCP) implementation for connecting to and working with various database systems.
    178
    12
    TypeScript
    MIT License
  • Why this server?

    Provides a unified database access interface to PostgreSQL databases, allowing SQL query execution, table structure retrieval, and database analysis capabilities.

    -
    security
    A
    license
    -
    quality
    DButils is an all-in-one MCP service that enables your AI to do data analysis by accessing versatile types of database (sqlite, mysql, postgres, and more) within a unified connection configuration in a safe way.
    16
    Python
    MIT License
    • Linux
    • Apple
  • Why this server?

    Supports using PostgreSQL as a database option when scaffolding Payload CMS projects.

    -
    security
    A
    license
    -
    quality
    Enables management of Payload CMS projects through natural language commands, allowing developers to create, configure, and deploy content models with conversational AI.
    82
    21
    MIT License
    • Linux
    • Apple
  • Why this server?

    Mentioned as a possible catalog type that can be used with Trino through the MCP server

    -
    security
    A
    license
    -
    quality
    An MCP server that enables listing and querying Trino tables using Python, providing access to data resources through the Model-Control-Protocol.
    8
    Python
    MIT License
  • Why this server?

    Provides comprehensive PostgreSQL database management capabilities, including database analysis, schema management, data migration, and real-time monitoring. Enables analyzing configurations, debugging issues, creating and altering tables, exporting/importing data between databases, and monitoring performance metrics.

    -
    security
    A
    license
    -
    quality
    A Model Context Protocol server that enables powerful PostgreSQL database management capabilities including analysis, schema management, data migration, and monitoring through natural language interactions.
    7
    TypeScript
    AGPL 3.0
    • Linux
    • Apple
  • Why this server?

    Supports SQL output format with PostgreSQL dialect for random user data, including CREATE TABLE statements and proper type handling.

    -
    security
    A
    license
    -
    quality
    Provides enhanced access to the randomuser.me API with advanced features like custom formatting, password generation, and weighted nationality distribution.
    JavaScript
    MIT License
  • Why this server?

    Used for storing users, API keys, and transaction records in the MCP blockchain server system

    -
    security
    A
    license
    -
    quality
    A secure system enabling AI assistants to interact with blockchain data and prepare transactions while ensuring users maintain exclusive control over their private keys and transaction signing.
    3
    TypeScript
    MIT License
  • Why this server?

    Provides direct access to PostgreSQL databases for executing SQL queries, managing database schemas, and handling transactions with robust safety controls for both read-only and data modification operations.

    -
    security
    A
    license
    -
    quality
    Enables Cursor and Windsurf to safely interact with Supabase databases by providing tools for database management, SQL query execution, and Supabase Management API access with built-in safety controls.
    7
    Python
    Apache 2.0
    • Apple
    • Linux
  • Why this server?

    Provides read-only access to PostgreSQL databases with multi-schema support, allowing inspection of database schemas across multiple namespaces and execution of read-only SQL queries while maintaining schema isolation.

    -
    security
    A
    license
    -
    quality
    A Model Context Protocol server that provides read-only access to PostgreSQL databases with enhanced multi-schema support, allowing LLMs to inspect database schemas across multiple namespaces and execute read-only queries while maintaining schema isolation.
    13
    2
    JavaScript
    MIT License
  • Why this server?

    Provides tools for connecting to, querying, and exploring PostgreSQL databases, including schema discovery, query execution, and analysis of execution plans.

    -
    security
    F
    license
    -
    quality
    PG-MCP is an HTTP server implementation that enables AI systems to interact with PostgreSQL databases via MCP, providing tools for querying, connecting to multiple databases, and exploring schema resources. The system enriches context by extracting table/column description from database catalogs.
    6
    • Linux
    • Apple
  • Why this server?

    Provides tools for executing SQL queries against PostgreSQL databases, including SELECT, CREATE/INSERT, UPDATE, and DELETE operations

    -
    security
    F
    license
    -
    quality
    A Model Context Protocol server that provides tools for interacting with databases, including PostgreSQL, DuckDB, and Google Cloud Storage Parquet files.
    TypeScript
    • Linux
    • Apple
  • Why this server?

    Provides a read-only query interface to PostgreSQL databases, supporting secure connections via SSH bastion tunnels

    -
    security
    F
    license
    -
    quality
    A TypeScript implementation of a Model Context Protocol server that enables language models to securely query PostgreSQL databases, including those behind SSH bastion tunnels.
    90
    TypeScript
  • Why this server?

    Stores user interactions, context metadata, and tracking data for the AI customer support system.

  • Why this server?

    The MCP server supports PostgreSQL with pgvector as a production-ready storage backend option for the knowledge base

    -
    security
    F
    license
    -
    quality
    An MCP server aimed to be portable, local, easy and convenient to support semantic/graph based retrieval of txtai "all in one" embeddings database. Any txtai embeddings db in tar.gz form can be loaded
    18
    Python
    • Linux
    • Apple
  • Why this server?

    Provides full read-write access to PostgreSQL databases, allowing query execution, data modification, schema management, and detailed database exploration with safety controls and transaction management

    -
    security
    F
    license
    -
    quality
    A Model Context Protocol server that provides LLMs with full read-write access to PostgreSQL databases, allowing both querying and modifying database content with transaction management and safety controls.
    1
    TypeScript
    • Apple
  • Why this server?

    Provides advanced database interaction capabilities for PostgreSQL, including detailed schema inspection with metadata, read-only query execution with safety checks, and tools for exploring database structure while enforcing security constraints.

    -
    security
    F
    license
    -
    quality
    An enhanced Model Context Protocol server that enables LLMs to inspect database schemas with rich metadata and execute read-only SQL queries with safety checks.
    177
    1
    TypeScript
    • Apple
  • Why this server?

    Provides read-only access to PostgreSQL databases, enabling schema inspection and execution of read-only SQL queries against connected databases.

    -
    security
    F
    license
    -
    quality
    Provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only SQL queries.
    23,627
    JavaScript
    • Apple
  • Why this server?

    Enables interaction with PostgreSQL databases, allowing users to list tables, retrieve schemas, and execute read-only SQL queries against PostgreSQL databases.

    -
    security
    F
    license
    -
    quality
    A Model Context Protocol server that enables interaction with PostgreSQL databases to list tables, retrieve schemas, and execute read-only SQL queries.
    23,627
    JavaScript
    • Linux
    • Apple
  • Why this server?

    Enables querying and interacting with PostgreSQL databases through SQL execution tools and schema resources

    -
    security
    F
    license
    -
    quality
    A server that helps people access and query data in databases using the Query Runner with integration of the Model Context Protocol (MCP) Python SDK. Support databases including PostgreSQL Redshift MySQL Microsoft SQL Server Google APIs Amazon Web Services (via boto3) CockroachDB SQLite
    6
    Python
    GPL 3.0
    • Linux
    • Apple
  • Why this server?

    Provides both read and write access to PostgreSQL databases, allowing for data querying, data modification (insert, update, delete), and schema management (creating tables, functions, triggers, indexes).

    -
    security
    F
    license
    -
    quality
    A Model Context Protocol server providing both read and write access to PostgreSQL databases, enabling LLMs to query data, modify records, and manage database schemas.
    4
    JavaScript
  • Why this server?

    Provides database operations for PostgreSQL, enabling CRUD operations on User and Post entities with type-safe queries through the MCP interface

    -
    security
    F
    license
    -
    quality
    A Model Context Protocol server that enables performing PostgreSQL database operations (create, read, update, delete) on User and Post entities through MCP tools.
    TypeScript
  • Why this server?

    Enables database interaction with PostgreSQL, with a dedicated template for handling database operations

    -
    security
    F
    license
    -
    quality
    A tool that generates MCP servers for Smithery with Cursor IDE integration, allowing users to quickly create servers from templates such as Basic, Web Search, or Database interactions.
    JavaScript
  • Why this server?

    Allows analyzing data from PostgreSQL databases, calculating statistics, and generating ML predictions based on database content

    -
    security
    F
    license
    -
    quality
    Enables LLMs to perform statistical analysis and generate ML predictions on user data from databases or CSV files through a Model Context Protocol server.
    Python
  • Why this server?

    Connects directly to a PostgreSQL database to access and serve Talent profiles with their aesthetic characteristics and design attributes

    -
    security
    F
    license
    -
    quality
    An MCP server that provides access to Talent AI profiles and styling capabilities for dynamic UI component styling, connecting to PostgreSQL to serve detailed talent profiles with aesthetic characteristics and design attributes.
    TypeScript
  • Why this server?

    Provides read-only access to PostgreSQL databases, allowing for schema inspection and execution of read-only SQL queries against connected databases.

    -
    security
    F
    license
    -
    quality
    Provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only SQL queries within a secure transaction context.
    23,627
    JavaScript
    • Apple
  • Why this server?

    Provides vector similarity search capabilities using pgvector extension for efficient storage and retrieval of memory embeddings

    -
    security
    F
    license
    -
    quality
    Implements long-term memory capabilities for AI assistants using PostgreSQL with pgvector for efficient vector similarity search, enabling semantic retrieval of stored information.
    1
    JavaScript
    • Apple
    • Linux
  • Why this server?

    Enables direct management of PostgreSQL databases with tools for tables, columns, records, indexes, constraints, functions, triggers, and executing custom SQL queries.

    -
    security
    F
    license
    -
    quality
    A powerful server that provides administrative control over Supabase PostgreSQL databases through Cursor's Composer and Codeium's Cascade, enabling database management with features for tables, records, schema modifications, and more.
    9
    10
    TypeScript
    • Apple
    • Linux
  • Why this server?

    Connects to a PostgreSQL database via MCP, allowing AI models to execute SQL queries with retry logic, view database schema information, and interact with database tables while handling connection errors gracefully.

    -
    security
    F
    license
    -
    quality
    A server that allows AI models to interact with PostgreSQL databases through a standardized protocol, providing database schema information and SQL query execution capabilities.
    JavaScript
  • Why this server?

    Provides a secure read-only interface to PostgreSQL databases, allowing execution of validated SELECT queries with timeout protection

    -
    security
    F
    license
    -
    quality
    A secure Model Context Protocol server that allows Claude to execute read-only SQL queries against a PostgreSQL database, enabling natural language interaction with database data.
    TypeScript
    • Apple
  • Why this server?

    Allows creating, configuring, and managing PostgreSQL databases within Coolify, including memory limits, port configuration, and password updates.

    -
    security
    F
    license
    -
    quality
    A Model Context Protocol server that enables AI assistants to interact with Coolify instances through natural language, allowing management of servers, applications, databases, and deployments.
    85
    2
    TypeScript
  • Why this server?

    Enables read-only SQL queries against a PostgreSQL database, with tools for analyzing table statistics and relationships between tables

    -
    security
    F
    license
    -
    quality
    An MCP server that connects to Supabase PostgreSQL databases, exposing table schemas as resources and providing tools for data analysis through SQL queries.
    JavaScript
  • Why this server?

    Enables interaction with PostgreSQL databases, including connection management, query execution, and transaction handling

    -
    security
    F
    license
    -
    quality
    A comprehensive Model Context Protocol server implementation that enables AI assistants to interact with file systems, databases, GitHub repositories, web resources, and system tools while maintaining security and control.
    16
    TypeScript
  • Why this server?

    Provides tools for exploring and querying a PostgreSQL database, including executing read-only SQL queries, listing tables, and obtaining schema information for specific tables.

    -
    security
    F
    license
    -
    quality
    A server implementing the Model Context Protocol (MCP) for Cursor that allows using a PostgreSQL database as storage for model contexts, enabling secure database exploration and querying.
    JavaScript
    • Linux
    • Apple
  • Why this server?

    Provides database functionality for storing and retrieving educational content and question data

    -
    security
    F
    license
    -
    quality
    Enables Claude Desktop to interact with the Gauntlet Incept system for generating, tagging, and grading educational content for K-8 students directly through natural language.
    1
    JavaScript
  • Why this server?

    Provides read-only access to PostgreSQL databases, allowing LLMs to inspect database schemas and execute read-only queries

    -
    security
    F
    license
    -
    quality
    Provides read-only access to PostgreSQL databases, enabling users to inspect database schemas and execute read-only queries through a Model Context Protocol server.
    3
    JavaScript
  • Why this server?

    Allows direct interaction with PostgreSQL databases through natural language queries, enabling conversational data exploration and manipulation.

    -
    security
    F
    license
    -
    quality
    A server that enables interaction with PostgreSQL, MySQL, MariaDB, or SQLite databases through Claude Desktop using natural language queries.
    Python
  • Why this server?

    Provides natural language interface to PostgreSQL databases, enabling SQL query generation, schema-aware responses, and read-only data access through the Model Context Protocol.

    -
    security
    F
    license
    -
    quality
    An interactive chat interface that combines Ollama's LLM capabilities with PostgreSQL database access through the Model Context Protocol (MCP). Ask questions about your data in natural language and get AI-powered responses backed by real SQL queries.
    28
    TypeScript