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

よくある質問

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`.

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).

What tools are available?

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

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`.

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`.