SQLite 数据库

数据与存储编辑精选

SQLite

by Anthropic

SQLite 是让 AI 直接查询本地数据库进行数据分析的 MCP 服务器。

这个服务器解决了 AI 无法直接访问 SQLite 数据库的问题,适合需要快速分析本地数据集的开发者。不过,作为参考实现,它可能缺乏生产级的安全特性,建议在受控环境中使用。

85.2kGitHub

什么是 SQLite 数据库

SQLite 是让 AI 直接查询本地数据库进行数据分析的 MCP 服务器。

如何使用 SQLite 数据库

安装命令

npx -y @modelcontextprotocol/server-sqlite

README

Model Context Protocol servers

This repository is a collection of reference implementations for the Model Context Protocol (MCP), as well as references to community-built servers and additional resources.

[!IMPORTANT] If you are looking for a list of MCP servers, you can browse published servers on the MCP Registry. The repository served by this README is dedicated to housing just the small number of reference servers maintained by the MCP steering group.

[!WARNING] The servers in this repository are intended as reference implementations to demonstrate MCP features and SDK usage. They are meant to serve as educational examples for developers building their own MCP servers, not as production-ready solutions. Developers should evaluate their own security requirements and implement appropriate safeguards based on their specific threat model and use case.

The servers in this repository showcase the versatility and extensibility of MCP, demonstrating how it can be used to give Large Language Models (LLMs) secure, controlled access to tools and data sources. Typically, each MCP server is implemented with an MCP SDK:

🌟 Reference Servers

These servers aim to demonstrate MCP features and the official SDKs.

  • Everything - Reference / test server with prompts, resources, and tools.
  • Fetch - Web content fetching and conversion for efficient LLM usage.
  • Filesystem - Secure file operations with configurable access controls.
  • Git - Tools to read, search, and manipulate Git repositories.
  • Memory - Knowledge graph-based persistent memory system.
  • Sequential Thinking - Dynamic and reflective problem-solving through thought sequences.
  • Time - Time and timezone conversion capabilities.

Archived

The following reference servers are now archived and can be found at servers-archived.

  • AWS KB Retrieval - Retrieval from AWS Knowledge Base using Bedrock Agent Runtime.
  • Brave Search - Web and local search using Brave's Search API. Has been replaced by the official server.
  • EverArt - AI image generation using various models.
  • GitHub - Repository management, file operations, and GitHub API integration.
  • GitLab - GitLab API, enabling project management.
  • Google Drive - File access and search capabilities for Google Drive.
  • Google Maps - Location services, directions, and place details.
  • PostgreSQL - Read-only database access with schema inspection.
  • Puppeteer - Browser automation and web scraping.
  • Redis - Interact with Redis key-value stores.
  • Sentry - Retrieving and analyzing issues from Sentry.io.
  • Slack - Channel management and messaging capabilities. Now maintained by Zencoder
  • SQLite - Database interaction and business intelligence capabilities.

📚 Frameworks

These are high-level frameworks that make it easier to build MCP servers or clients.

For servers

  • Anubis MCP (Elixir) - A high-performance and high-level Model Context Protocol (MCP) implementation in Elixir. Think like "Live View" for MCP.
  • ModelFetch (TypeScript) - Runtime-agnostic SDK to create and deploy MCP servers anywhere TypeScript/JavaScript runs
  • EasyMCP (TypeScript)
  • FastAPI to MCP auto generator – A zero-configuration tool for automatically exposing FastAPI endpoints as MCP tools by Tadata
  • FastMCP (TypeScript)
  • Foobara MCP Connector - Easily expose Foobara commands written in Ruby as tools via MCP
  • Foxy Contexts – A library to build MCP servers in Golang by strowk
  • Higress MCP Server Hosting - A solution for hosting MCP Servers by extending the API Gateway (based on Envoy) with wasm plugins.
  • MCP Declarative Java SDK Annotation-driven MCP servers development with Java, no Spring Framework Required, minimize dependencies as much as possible.
  • MCP-Framework Build MCP servers with elegance and speed in TypeScript. Comes with a CLI to create your project with mcp create app. Get started with your first server in under 5 minutes by Alex Andru
  • MCP Plexus: A secure, multi-tenant and Multi-user MCP python server framework built to integrate easily with external services via OAuth 2.1, offering scalable and robust solutions for managing complex AI applications.
  • mcp_sse (Elixir) An SSE implementation in Elixir for rapidly creating MCP servers.
  • mxcp (Python) - Open-source framework for building enterprise-grade MCP servers using just YAML, SQL, and Python, with built-in auth, monitoring, ETL and policy enforcement.
  • Next.js MCP Server Template (Typescript) - A starter Next.js project that uses the MCP Adapter to allow MCP clients to connect and access resources.
  • PayMCP (Python & TypeScript) - Lightweight payments layer for MCP servers: turn tools into paid endpoints with a two-line decorator. PyPI · npm · TS repo
  • Perl SDK - An SDK for building MCP servers and clients with the Perl programming language.
  • Quarkus MCP Server SDK (Java)
  • R mcptools - An R SDK for creating R-based MCP servers and retrieving functionality from third-party MCP servers as R functions.
  • SAP ABAP MCP Server SDK - Build SAP ABAP based MCP servers. ABAP 7.52 based with 7.02 downport; runs on R/3 & S/4HANA on-premises, currently not cloud-ready.
  • Spring AI MCP Server - Provides auto-configuration for setting up an MCP server in Spring Boot applications.
  • Template MCP Server - A CLI tool to create a new Model Context Protocol server project with TypeScript support, dual transport options, and an extensible structure
  • AgentR Universal MCP SDK - A python SDK to build MCP Servers with inbuilt credential management by Agentr
  • Vercel MCP Adapter (TypeScript) - A simple package to start serving an MCP server on most major JS meta-frameworks including Next, Nuxt, Svelte, and more.
  • PHP MCP Server (PHP) - Core PHP implementation for the Model Context Protocol (MCP) server

For clients

  • codemirror-mcp - CodeMirror extension that implements the Model Context Protocol (MCP) for resource mentions and prompt commands
  • llm-analysis-assistant <img height="12" width="12" src="https://raw.githubusercontent.com/xuzexin-hz/llm-analysis-assistant/refs/heads/main/src/llm_analysis_assistant/pages/html/imgs/favicon.ico" alt="Langfuse Logo" /> - A very streamlined mcp client that supports calling and monitoring stdio/sse/streamableHttp, and can also view request responses through the /logs page. It also supports monitoring and simulation of ollama/openai interface.
  • MCP-Agent - A simple, composable framework to build agents using Model Context Protocol by LastMile AI
  • Spring AI MCP Client - Provides auto-configuration for MCP client functionality in Spring Boot applications.
  • MCP CLI Client - A CLI host application that enables Large Language Models (LLMs) to interact with external tools through the Model Context Protocol (MCP).
  • OpenMCP Client - An all-in-one vscode/trae/cursor plugin for MCP server debugging. Document & OpenMCP SDK.
  • PHP MCP Client - Core PHP implementation for the Model Context Protocol (MCP) Client
  • Runbear - No-code MCP client for team chat platforms, such as Slack, Microsoft Teams, and Discord.

📚 Resources

Additional resources on MCP.

  • A2A-MCP Java Bridge - A2AJava brings powerful A2A-MCP integration directly into your Java applications. It enables developers to annotate standard Java methods and instantly expose them as MCP Server, A2A-discoverable actions — with no boilerplate or service registration overhead.
  • AiMCP - A collection of MCP clients&servers to find the right mcp tools by Hekmon
  • Awesome Crypto MCP Servers by badkk - A curated list of MCP servers by Luke Fan
  • Awesome MCP Servers by appcypher - A curated list of MCP servers by Stephen Akinyemi
  • Awesome MCP Servers by punkpeye (website) - A curated list of MCP servers by Frank Fiegel
  • Awesome MCP Servers by wong2 (website) - A curated list of MCP servers by wong2
  • Awesome Remote MCP Servers by JAW9C - A curated list of remote MCP servers, including their authentication support by JAW9C
  • Discord Server – A community discord server dedicated to MCP by Frank Fiegel
  • Install This MCP - Reduce Installation Friction with beautiful installation guides
  • <img height="12" width="12" src="https://raw.githubusercontent.com/klavis-ai/klavis/main/static/klavis-ai.png" alt="Klavis Logo" /> Klavis AI - Open Source MCP Infra. Hosted MCP servers and MCP clients on Slack and Discord.
  • MCP Badges – Quickly highlight your MCP project with clear, eye-catching badges, by Ironben
  • <img height="12" width="12" src="https://mcpproxy.app/favicon.svg" alt="MCPProxy Logo" /> MCPProxy - Open-source local app that enables access to multiple MCP servers and thousands of tools with intelligent discovery via MCP protocol, runs servers in isolated environments, and features automatic quarantine protection against malicious tools.
  • MCPRepository.com - A repository that indexes and organizes all MCP servers for easy discovery.
  • mcp-cli - A CLI inspector for the Model Context Protocol by wong2
  • mcp-dockmaster - An Open-Sourced UI to install and manage MCP servers for Windows, Linux and macOS.
  • mcp-get - Command line tool for installing and managing MCP servers by Michael Latman
  • mcp-guardian - GUI application + tools for proxying / managing control of MCP servers by EQTY Lab
  • MCP Linker - A cross-platform Tauri GUI tool for one-click setup and management of MCP servers, supporting Claude Desktop, Cursor, Windsurf, VS Code, Cline, and Neovim.
  • mcp-manager - Simple Web UI to install and manage MCP servers for Claude Desktop by Zue
  • MCP Marketplace Web Plugin MCP Marketplace is a small Web UX plugin to integrate with AI applications, Support various MCP Server API Endpoint (e.g pulsemcp.com/deepnlp.org and more). Allowing user to browse, paginate and select various MCP servers by different categories. Pypi | Maintainer | Website
  • mcp.natoma.ai – A Hosted MCP Platform to discover, install, manage and deploy MCP servers by Natoma Labs
  • mcp.run - A hosted registry and control plane to install & run secure + portable MCP Servers.
  • MCPHub - Website to list high quality MCP servers and reviews by real users. Also provide online chatbot for popular LLM models with MCP server support.
  • MCP Router – Free Windows and macOS app that simplifies MCP management while providing seamless app authentication and powerful log visualization by MCP Router
  • MCP Servers Hub (website) - A curated list of MCP servers by apappascs
  • MCPServers.com - A growing directory of high-quality MCP servers with clear setup guides for a variety of MCP clients. Built by the team behind the Highlight MCP client
  • MCP Servers Rating and User Reviews - Website to rate MCP servers, write authentic user reviews, and search engine for agent & mcp
  • MCP Sky - Bluesky feed for MCP related news and discussion by @brianell.in
  • MCP X Community – A X community for MCP by Xiaoyi
  • MCPHub – An Open Source macOS & Windows GUI Desktop app for discovering, installing and managing MCP servers by Jeamee
  • mcpm (website) - MCP Manager (MCPM) is a Homebrew-like service for managing Model Context Protocol (MCP) servers across clients by Pathintegral
  • MCPVerse - A portal for creating & hosting authenticated MCP servers and connecting to them securely.
  • MCP Servers Search - An MCP server that provides tools for querying and discovering available MCP servers from this list.
  • Search MCP Server - Recommends the most relevant MCP servers based on the client's query by searching this README file.
  • MCPWatch - A comprehensive security scanner for Model Context Protocol (MCP) servers that detects vulnerabilities and security issues in your MCP server implementations.
  • <img height="12" width="12" src="https://mkinf.io/favicon-lilac.png" alt="mkinf Logo" /> mkinf - An Open Source registry of hosted MCP Servers to accelerate AI agent workflows.
  • Open-Sourced MCP Servers Directory - A curated list of MCP servers by mcpso
  • <img height="12" width="12" src="https://opentools.com/favicon.ico" alt="OpenTools Logo" /> OpenTools - An open registry for finding, installing, and building with MCP servers by opentoolsteam
  • Programmatic MCP Prototype - Experimental agent prototype demonstrating programmatic MCP tool composition, progressive tool discovery, state persistence, and skill building through TypeScript code execution by Adam Jones
  • PulseMCP (API) - Community hub & weekly newsletter for discovering MCP servers, clients, articles, and news by Tadas Antanavicius, Mike Coughlin, and Ravina Patel
  • r/mcp – A Reddit community dedicated to MCP by Frank Fiegel
  • MCP.ing - A list of MCP services for discovering MCP servers in the community and providing a convenient search function for MCP services by iiiusky
  • MCP Hunt - Realtime platform for discovering trending MCP servers with momentum tracking, upvoting, and community discussions - like Product Hunt meets Reddit for MCP
  • Smithery - A registry of MCP servers to find the right tools for your LLM agents by Henry Mao
  • Toolbase - Desktop application that manages tools and MCP servers with just a few clicks - no coding required by gching
  • ToolHive - A lightweight utility designed to simplify the deployment and management of MCP servers, ensuring ease of use, consistency, and security through containerization by StacklokLabs
  • NetMind - Access powerful AI services via simple APIs or MCP servers to supercharge your productivity.
  • Webrix MCP Gateway - Enterprise MCP gateway with SSO, RBAC, audit trails, and token vaults for secure, centralized AI agent access control. Deploy via Helm charts on-premise or in your cloud. webrix.ai

🚀 Getting Started

Using MCP Servers in this Repository

TypeScript-based servers in this repository can be used directly with npx.

For example, this will start the Memory server:

sh
npx -y @modelcontextprotocol/server-memory

Python-based servers in this repository can be used directly with uvx or pip. uvx is recommended for ease of use and setup.

For example, this will start the Git server:

sh
# With uvx
uvx mcp-server-git

# With pip
pip install mcp-server-git
python -m mcp_server_git

Follow these instructions to install uv / uvx and these to install pip.

Using an MCP Client

However, running a server on its own isn't very useful, and should instead be configured into an MCP client. For example, here's the Claude Desktop configuration to use the above server:

json
{
  "mcpServers": {
    "memory": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-memory"]
    }
  }
}

On Windows, wrap npx with cmd /c:

json
{
  "mcpServers": {
    "memory": {
      "command": "cmd",
      "args": ["/c", "npx", "-y", "@modelcontextprotocol/server-memory"]
    }
  }
}

Additional examples of using the Claude Desktop as an MCP client might look like:

json
{
  "mcpServers": {
    "filesystem": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-filesystem", "/path/to/allowed/files"]
    },
    "git": {
      "command": "uvx",
      "args": ["mcp-server-git", "--repository", "path/to/git/repo"]
    },
    "github": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-github"],
      "env": {
        "GITHUB_PERSONAL_ACCESS_TOKEN": "<YOUR_TOKEN>"
      }
    },
    "postgres": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-postgres", "postgresql://localhost/mydb"]
    }
  }
}

On Windows, apply the same wrapper to each npx-based entry above by changing "command" to "cmd" and prepending "/c", "npx" to the existing args. Leave uvx entries unchanged.

🛠️ Creating Your Own Server

Interested in creating your own MCP server? Visit the official documentation at modelcontextprotocol.io for comprehensive guides, best practices, and technical details on implementing MCP servers.

🤝 Contributing

See CONTRIBUTING.md for information about contributing to this repository.

🔒 Security

See SECURITY.md for reporting security vulnerabilities.

📜 License

This project is licensed under the Apache License, Version 2.0 for new contributions, with existing code under MIT - see the LICENSE file for details.

💬 Community

⭐ Support

If you find MCP servers useful, please consider starring the repository and contributing new servers or improvements!


Managed by Anthropic, but built together with the community. The Model Context Protocol is open source and we encourage everyone to contribute their own servers and improvements!

常见问题

SQLite 数据库 是什么?

读取和查询 SQLite 数据库,用于数据分析任务。

如何安装 SQLite 数据库

运行命令:npx -y @modelcontextprotocol/server-sqlite

相关 Skills

技术栈评估

by alirezarezvani

Universal
热门

对比框架、数据库和云服务,结合 5 年 TCO、安全风险、生态活力与迁移复杂度做量化评估,适合技术选型、栈升级和替换路线决策。

帮你系统比较技术栈优劣,不只看功能,还把TCO、安全性和生态健康度一起量化,选型和迁移决策更稳。

数据与存储
未扫描14.1k

资深架构师

by alirezarezvani

Universal
热门

适合系统设计评审、ADR记录和扩展性规划,分析依赖与耦合,权衡单体或微服务、数据库与技术栈选型,并输出Mermaid、PlantUML、ASCII架构图。

搞系统设计、技术选型和扩展规划时,用它能更快理清架构决策与依赖关系,还能直接产出 Mermaid/PlantUML 图,方案讨论效率很高。

数据与存储
未扫描14.1k

资深数据科学家

by alirezarezvani

Universal
热门

覆盖实验设计、特征工程、预测建模、因果推断与模型评估,适合用 Python/R/SQL 做 A/B 测试、时序分析和生产级 ML 落地,支撑数据驱动决策。

从 A/B 测试、因果分析到预测建模一条龙搞定,既有硬核统计方法也懂业务沟通,特别适合把数据结论真正落地。

数据与存储
未扫描14.1k

相关 MCP Server

by Anthropic

热门

PostgreSQL 是让 Claude 直接查询和管理你的数据库的 MCP 服务器。

这个服务器解决了开发者需要手动编写 SQL 查询的痛点,特别适合数据分析师或后端开发者快速探索数据库结构。不过,由于是参考实现,生产环境使用前务必评估安全风险,别指望它能处理复杂事务。

数据与存储
85.2k

by Firecrawl

热门

Firecrawl 是让 AI 直接抓取网页并提取结构化数据的 MCP 服务器。

它解决了手动写爬虫的麻烦,让 Claude 能直接访问动态网页内容。最适合需要实时数据的研究者或开发者,比如监控竞品价格或抓取新闻。但要注意,它依赖第三方 API,可能涉及隐私和成本问题。

数据与存储
6.2k

by bytebase

热门

DBHub 是让 Claude 等 AI 助手直接查询和探索多种数据库的轻量级网关。

如果你想让 AI 助手帮你分析数据库结构或执行安全查询,DBHub 就是那个桥梁。它支持 PostgreSQL、MySQL 等主流数据库,配置简单,还内置了只读模式和行数限制来防止误操作。不过,目前它只提供两个核心工具,复杂的数据操作还得靠你自己写 SQL。适合需要快速探索数据库的开发者,但别指望它替代完整的数据库管理工具。

数据与存储
2.7k

评论