mcp_sqlite_poc

mcp_sqlite_poc

0
databases

The SQLite MCP Server is a Model Context Protocol server facilitating interaction between AI models and SQLite databases using standardized tools. It offers features like query execution, schema discovery, and feedback collection and supports both read-only and write operations with security considerations.

SQLite MCP Server

A Model Context Protocol (MCP) server designed for SQLite databases, enabling AI models to interact with databases through standardized tools.

Features

  • Query Execution: Run SQL queries with validation and safety
  • Schema Discovery: Identify table structures
  • Row Counting: Count entries in tables
  • Sample Data: Add demo data (if not in read-only mode)
  • Automatic Initialization: Create a demo database if necessary
  • Read-Only Mode: Limit operations to safe reads
  • Feedback Collection: Record user feedback in the database

Requirements

  • Python 3.8+

Usage

Starting the Server

  • Start the server on port 8080 or specified port.

Configuration Options

  • Modify .env file for settings.

Tools

  • Execute SQL queries
  • List and describe tables
  • Count table rows
  • Insert sample data