MCP Postgres Server

MCP Postgres Server

Mirror of

MCP-Mirror

Databases
Visit Server

README

MCP Postgres Server

Ce serveur implémente le protocole MCP (Model Context Protocol) pour Cursor, permettant d'utiliser une base de données PostgreSQL comme stockage pour les contextes de modèle.

Prérequis

  • Docker
  • Docker Compose

Installation et démarrage

  1. Clonez ce dépôt
  2. Démarrez le serveur avec Docker Compose:
docker-compose up -d

Configuration dans Cursor

  1. Ouvrez Cursor
  2. Allez dans Paramètres > MCP
  3. Ajoutez une nouvelle connexion avec les paramètres suivants:
    • Nom: MCP Postgres Server
    • Type: command
    • Commande: docker exec -i mcp-postgres-server node dist/index.js

Résolution des problèmes

Si le serveur ne démarre pas correctement:

  1. Vérifiez les logs du conteneur:

    docker logs mcp-postgres-server

  2. Pour redémarrer le serveur:

    docker-compose restart

Fonctionnalités du serveur MCP

Le serveur MCP PostgreSQL expose les outils suivants pour Cursor:

  1. postgres_query - Exécuter une requête SQL en lecture seule
  2. postgres_list_tables - Lister toutes les tables de la base de données
  3. postgres_describe_table - Obtenir le schéma d'une table spécifique

Ces outils permettent à Cursor d'explorer et d'interroger la base de données de manière sécurisée.

Recommended Servers

Metabase MCP Server

Metabase MCP Server

Enables AI assistants to interact with Metabase databases and dashboards, allowing users to list and execute queries, access data visualizations, and interact with database resources through natural language.

Featured
JavaScript
Airtable MCP Server

Airtable MCP Server

A Model Context Protocol server that provides tools for programmatically managing Airtable bases, tables, fields, and records through Claude Desktop or other MCP clients.

Featured
JavaScript
mcp-shodan

mcp-shodan

MCP server for querying the Shodan API and Shodan CVEDB. This server provides tools for IP lookups, device searches, DNS lookups, vulnerability queries, CPE lookups, and more.

Featured
JavaScript
Supabase MCP Server

Supabase MCP Server

A Model Context Protocol (MCP) server that provides programmatic access to the Supabase Management API. This server allows AI models and other clients to manage Supabase projects and organizations through a standardized interface.

Featured
JavaScript
MCP DuckDB Knowledge Graph Memory Server

MCP DuckDB Knowledge Graph Memory Server

A memory server for Claude that stores and retrieves knowledge graph data in DuckDB, enhancing performance and query capabilities for conversations with persistent user information.

Featured
TypeScript
dbt Semantic Layer MCP Server

dbt Semantic Layer MCP Server

A server that enables querying the dbt Semantic Layer through natural language conversations with Claude Desktop and other AI assistants, allowing users to discover metrics, create queries, analyze data, and visualize results.

Featured
TypeScript
Verodat MCP Server

Verodat MCP Server

An MCP server that integrates Verodat's data management capabilities with AI systems like Claude Desktop, enabling users to manage accounts, workspaces, and datasets, as well as perform AI-powered queries on their data.

Official
Local
TypeScript
GreptimeDB MCP Server

GreptimeDB MCP Server

A Model Context Protocol server implementation that enables AI assistants to securely interact with GreptimeDB, allowing them to explore database schema, read data, and execute SQL queries through a controlled interface.

Official
Python
LlamaCloud MCP Server

LlamaCloud MCP Server

A MCP server connecting to a managed index on LlamaCloud. This is a TypeScript-based MCP server that implements a connection to a managed index on LlamaCloud.

Official
JavaScript
MongoDB MCP Server

MongoDB MCP Server

Provides read-only access to MongoDB databases for LLMs to inspect collection schemas and execute aggregation pipelines.

Official
JavaScript