Model Context Protocol Examples

🚀 SQLite Database Demo

This project demonstrates the usage of an SQLite database with asynchronous support in a FastMCP application.

🚀 Quick Start

To get started with this project, follow these steps:

1. Clone this repository.
2. Install the required dependencies:

pip install -r requirements.txt

3. Start the server:

python server.py

4. The database will be automatically initialized and sample data will be inserted on the first run.
5. Use the query_db tool to retrieve data from the database.

✨ Features

• Asynchronous SQLite database operations using aiosqlite.
• Automatic database initialization and insertion of sample data.
• Type-safe database context management.
• Proper handling of connection lifecycle.

📦 Installation

1. Clone this repository.
2. Install the required dependencies:

pip install -r requirements.txt

📚 Documentation

Project Structure

• server.py: The main FastMCP server implementation with database context management.
• database.py: The SQLite database implementation with asynchronous support.
• demo.db: The SQLite database file (automatically created on the first run).

Database Schema

The demo database contains a users table with the following structure:

CREATE TABLE users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    email TEXT UNIQUE NOT NULL
)

The following sample data will be automatically inserted on the first run:

• John Doe (john@example.com)
• Jane Smith (jane@example.com)

Database Operations

The Database class provides the following methods:

• connect(): Create a new database connection and initialize the schema.
• query(): Execute a sample query to retrieve all users.
• disconnect(): Close the database connection.

Customization

To modify the database schema or add new tables:

1. Edit the _init_db() method in database.py.
2. Add new methods to the Database class to implement custom queries.
3. Update the query_db tool in server.py to use the new methods.

Error Handling

The database implementation includes:

• Automatic cleanup of connections when the server is shut down.
• Proper handling of asynchronous context management.
• Type safety using Python type hints.