mcp-sqlite-server

mcp-sqlite-server

7
databases

The SQLite MCP Server is designed to connect to a SQLite database, allowing users to execute read-only SQL queries and access table schemas in support of data analysis tasks. It uses the Model Context Protocol to interact with clients and language models, ensuring smooth and efficient data handling.

Overview

The SQLite MCP Server is a Python-based Model Context Protocol server that interacts with a SQLite database containing startup funding data. Key features include:

  • Connecting to a SQLite database and exposing table schemas as resources.
  • Executing read-only SQL queries using a tool provided by the server.
  • Providing prompt templates for data analysis tasks.
  • Communicating with MCP clients and language models via the STDIO protocol.

Features

  • Exposes resources like table schemas and JSON mappings of schemas.
  • Tools for executing SQL queries limited to SELECT statements.
  • Prompt templates for generating data analysis insights.
  • Logging activities using Python’s logging module.

Setup and Installation

  • Instructions on creating a sample SQLite database, setting up a virtual environment, running the server, and integrating with Claude Desktop.

Usage

  • Access resources and invoke tools to execute SQL queries or generate SQL explanations.

Testing

  • Provides a test script to validate server operations such as listing resources and executing queries.

Logging

  • Configuration details for logging server activities and errors to a log file.