SQLite

Acerca de

mcp-sqlite functions as a Model Context Protocol (MCP) server, designed to bridge AI clients with local SQLite databases. It exposes a comprehensive set of tools—including opening databases, retrieving schemas, executing read-only queries, and performing write operations—allowing AI to interact with and manage data effortlessly. The server supports both STDIO and HTTP transport, features concurrent read operations, includes a configurable row cap for queries to manage LLM token budgets, and provides human-readable plain-text responses, making it an ideal companion for AI-driven database interactions.

Características Principales

• 0 GitHub stars
• Four dedicated MCP tools for database interaction: `open_database`, `get_schema`, `query`, `execute`
• Supports both STDIO and HTTP transport modes for flexible client integration
• Ensures safe concurrent read operations with serialized database access
• Configurable row capping for query results to optimize AI token usage
• Generates plain-text, human-readable responses for AI consumption

Casos de Uso

• Enabling AI clients to inspect and understand SQLite database schemas.
• Allowing AI to run ad-hoc read-only SQL queries on local data.
• Empowering AI to perform data modification (INSERT, UPDATE, DELETE) and DDL operations.