SQLite Database Demo

SQLite Database Demo

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

Features

• Async SQLite database operations using aiosqlite
• Automatic database initialization with sample data
• Type-safe database context management
• Proper connection lifecycle handling

Prerequisites

• Python 3.7+
• pip (Python package installer)

Installation

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

pip install -r requirements.txt

Project Structure

• server.py: Main FastMCP server implementation with database context management
• database.py: SQLite database implementation with async support
• demo.db: SQLite database file (created automatically on first run)

Database Schema

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

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

Sample data is automatically inserted on first run:

• John Doe ([email protected])
• Jane Smith ([email protected])

Usage

1. Start the server:

python server.py

2. The database will be automatically initialized with the sample data on first run.

3. Use the query_db tool to retrieve data from the database.

Database Operations

The Database class provides the following methods:

• connect(): Creates a new database connection and initializes the schema
• query(): Executes a sample query to retrieve all users
• disconnect(): Closes 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 Database class for custom queries
3. Update the query_db tool in server.py to use new methods

Error Handling

The database implementation includes:

• Automatic connection cleanup on server shutdown
• Proper async context management
• Type safety with Python type hints

Dependencies

• aiosqlite>=0.19.0: Async SQLite database driver
• pandas>=2.0.0: Data manipulation library
• numpy>=1.24.0: Numerical computing library