Advertise
MCP.so
Sign In

SQLite Database Demo MCP Server

@anhnx000

Repository

Basic information

Category

Databases

Transports

stdio

Author

anhnx000

About 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 config

Add this server to your MCP-compatible client using the configuration below.

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

SQLite Database Demo MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

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

Comments

More Databases MCP servers

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

NPILayer

NPILayer

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl

Elasticsearch MCP Server

elastic

685

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K
Advertise