MySQL & PostgreSQL MCP 服务器

by kaulvimal · data-analytics · mcp-server, lobehub, developer

Medium setupBest for productionTrust score 28/100

提供对数据库模式、元数据和查询执行的只读访问的 MCP 服务器，支持 MySQL 和 PostgreSQL。需要通过环境变量配置的 MySQL 或 PostgreSQL 数据库访问权限。

Source: https://github.com/kaulvimal/mysql-mcp

Install

git clone https://github.com/kaulvimal/mysql-mcp

Use this forAI-extracted

  • →Execute SQL queries against MySQL databases and retrieve structured results for data analysis
  • →Inspect database schemas, tables, and column definitions to understand data structure
  • →Perform CRUD operations on MySQL records programmatically through Claude agents
  • →Debug database issues by examining table contents and running diagnostic queries

Works with

Claude CodeClaude Desktop

Tags: mcp-server, lobehub, developer

⭐ 34 GitHub stars · Source: lobehub

About data-analytics MCP servers and Claude skills

data-analytics MCP servers extend what AI agents can do inside Claude Code, Cursor, Copilot, Codex, and Windsurf. The Skiln directory indexes 16,000+ such integrations across 22 categories.

MySQL & PostgreSQL MCP 服务器 is one of hundreds of data-analytics entries indexed on Skiln. Browse the full data-analytics category or the complete directory of Claude skills, MCP servers, agents, commands, and hooks.

Related data-analytics MCPs and skills

  • Food Facts MCP Server by razvannicolae

    An MCP server providing AI assistants real-time access to nutrition data from USDA FoodData Central and FatSecret APIs. Requires external API keys configured via environment variables USDA_FDC_API_KEY, FATSECRET_CLIENT_ID, and FATSECRET_CLIENT_SECRET. Caches data locally in SQLite with configurable cache path.

  • Nocturne Memory by Dataojitori

    Nocturne Memory is a long-term memory server for MCP agents, providing persistent, sovereign AI memory storage via Model Context Protocol. Requires external configuration of DATABASE_URL environment variable in .env file to specify the absolute path to the SQLite or PostgreSQL database file.

  • Advanced Windows MCP Server by yourusername

    A comprehensive Model Context Protocol (MCP) server designed for Windows environments, providing Claude Desktop with powerful system integration capabilities including file operations, task management, database queries, and system monitoring. The server automatically creates a SQLite database at %LOCALAPPDATA%\Claude\MCP\mcp_server.db for persistent storage.

  • MCP PDL Server by TheAgencyInstitute

    Product Development Lifecycle server with 7-phase project management, roadmap planning, and role-based collaboration. Requires a centralized SQLite database file located at ~/.claude/data/pdl.db.

  • AI 标签笔记 MCP 服务器 by WaleedFaridi07

    一个功能全面的笔记系统，配备AI驱动的内容丰富功能，支持多种界面和持久存储选项。支持SQLite（默认）、MySQL或内存数据库。AI内容丰富功能需要外部API密钥，可通过环境变量（如OPENAI_API_KEY、GROQ_API_KEY、HUGGINGFACE_API_KEY、OLLAMA_BASE_URL）进行配置。

  • CallGraph MCP Server by NicolasVautrin

    MCP Server for analyzing the call graph of Axelor projects. Requires external data files for the ChromaDB vector database, which are auto-detected in the current project directory (e.g., .vector-raw-db or .vector-semantic-db).

  • UniProt & Proteins API MCP Server by QuentinCody

    基于 Cloudflare Workers 构建的全面 UniProt 和 EBI 蛋白质 API 的模型上下文协议（MCP）服务器，具有使用 Durable Objects 和 SQLite 的高级数据分阶段能力。无需 API 密钥；UniProt 和 EBI 蛋白质 API 均为开放访问。

  • PostgreSQL MCP Server by devjoy.digital

    A Model Context Protocol (MCP) server that provides AI environments like Claude, Gemini, and OpenAI with powerful PostgreSQL database operations and flexible configuration management. Supports configuration via local JSON config files (.mcp-servers/.db-config.json, .claude/.db-config.json, etc.) or environment variables (POSTGRES_HOST, POSTGRES_PORT, POSTGRES_DATABASE, POSTGRES_USER, POSTGRES_PASSWORD, POSTGRES_SSL).

Frequently asked questions

How do I install MySQL & PostgreSQL MCP 服务器?

Add the install command above to your Claude Code, Cursor, or Windsurf MCP configuration. Most servers register via npx, a local command, or a Docker image. Refer to the source repository for environment variables and credential requirements.

Which clients support MySQL & PostgreSQL MCP 服务器?

Any MCP-compatible client works: Claude Desktop, Claude Code CLI, Cursor, Windsurf, Zed, and VS Code with the official MCP extension. OpenAI Codex and GitHub Copilot increasingly support MCP via adapter bridges.

Is MySQL & PostgreSQL MCP 服务器 free?

The server itself is typically open source. Any upstream service (API keys, paid tiers, hosted infrastructure) may have its own pricing. Check the source repository for details.