广告合作
MCP.so
登录

SQLite Database Demo MCP Server

@anhnx000

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

anhnx000

关于 SQLite Database Demo MCP Server

Some examples to build server, client test in model context protocol. Một số ví dụ sử dụng MCP

#sqlite#database#async#fastmcp

SQLite Database Demo MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "model_context_protocol_examples": {
      "command": "python",
      "args": [
        "server.py"
      ]
    }
  }
}

SQLite Database Demo MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is SQLite Database Demo?

SQLite Database Demo is an example FastMCP application that demonstrates async SQLite database operations using the aiosqlite library. It provides a ready‑to‑run server with automatic database initialization, sample data, and a query_db tool for retrieving records. This server is intended for developers learning or prototyping with FastMCP and async SQLite.

How to use SQLite Database Demo?

Clone the repository, install dependencies (pip install -r requirements.txt), then start the server with python server.py. On first run the database is automatically created and populated with sample data. Use the built‑in query_db tool to query all users.

Key features of SQLite Database Demo

  • Async SQLite operations via aiosqlite
  • Automatic database creation and sample data insertion
  • Type‑safe database context management
  • Proper connection lifecycle handling (cleanup on shutdown)
  • Simple query_db tool for retrieving all users

Use cases of SQLite Database Demo

  • Learning how to integrate async SQLite with FastMCP
  • Prototyping a FastMCP server that reads from a local database
  • Testing database‑related MCP tools without external infrastructure
  • Demonstrating connection lifecycle and error handling patterns

常见问题

1

What is the database schema?

The demo includes a `users` table with columns `id INTEGER PRIMARY KEY AUTOINCREMENT`, `name TEXT NOT NULL`, and `email TEXT UNIQUE NOT NULL`.

2

How is the database initialized?

On first run, `server.py` automatically creates `demo.db` and populates it with two sample users: John Doe (john@example.com) and Jane Smith (jane@example.com).

3

What tools are available?

The server exposes a `query_db` tool that executes a query returning all rows from the `users` table.

4

What are the runtime requirements?

Python 3.7 or higher, with dependencies `aiosqlite>=0.19.0`, `pandas>=2.0.0`, and `numpy>=1.24.0`.

5

How can I customize the database schema?

Edit the `_init_db()` method in `database.py` to add tables or columns. Add new query methods to the `Database` class and expose them through tools in `server.py`.

评论

数据库 分类下的更多 MCP 服务器

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

4

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617
广告合作