PostgreSQL MCP Server

PostgreSQL MCP Server

Enables AI models to execute SQL queries, list tables, and describe table structures on a local PostgreSQL database.

Category
Visit Server

README

PostgreSQL MCP Server

这是一个MCP (Model Context Protocol) 服务器，允许GPT-4等AI模型查询本地PostgreSQL数据库。

功能

  • 执行SQL查询
  • 列出数据库中的所有表
  • 获取表的结构信息

安装

  1. 克隆或下载项目
  2. 安装依赖：
npm install

配置

  1. 复制环境变量模板：
cp .env.example .env
  1. 编辑 .env 文件，配置你的PostgreSQL连接信息：
DB_HOST=localhost
DB_PORT=5432
DB_NAME=your_database_name
DB_USER=your_username
DB_PASSWORD=your_password

运行

开发模式

npm run dev

生产模式

npm run build
npm start

在Claude Desktop中配置

在Claude Desktop的配置文件中添加以下配置：

{
  "mcpServers": {
    "postgres": {
      "command": "node",
      "args": ["/path/to/your/project/index.js"],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "5432",
        "DB_NAME": "your_database_name",
        "DB_USER": "your_username",
        "DB_PASSWORD": "your_password"
      }
    }
  }
}

可用工具

query_database

执行SQL查询

  • query: SQL查询语句
  • params: 可选的查询参数数组

list_tables

列出数据库中的所有表

describe_table

获取指定表的结构信息

  • table_name: 表名

示例

一旦配置完成，你可以在Claude中使用以下命令：

  1. "列出数据库中的所有表"
  2. "描述users表的结构"
  3. "查询所有用户：SELECT * FROM users LIMIT 10"

Recommended Servers

playwright-mcp

playwright-mcp

A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.

Official
Featured
TypeScript
Magic Component Platform (MCP)

Magic Component Platform (MCP)

An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.

Official
Featured
Local
TypeScript
Audiense Insights MCP Server

Audiense Insights MCP Server

Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.

Official
Featured
Local
TypeScript
VeyraX MCP

VeyraX MCP

Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.

Official
Featured
Local
graphlit-mcp-server

graphlit-mcp-server

The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.

Official
Featured
TypeScript
Kagi MCP Server

Kagi MCP Server

An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.

Official
Featured
Python
E2B

E2B

Using MCP to run code via e2b.

Official
Featured
Neon Database

Neon Database

MCP server for interacting with Neon Management API and databases

Official
Featured
Exa Search

Exa Search

A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.

Official
Featured
Qdrant Server

Qdrant Server

This repository is an example of how to create a MCP server for Qdrant, a vector search engine.

Official
Featured