mcp-sqlite
If you are the rightful owner of mcp-sqlite and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
MCP SQLite Server is a Go-based MCP server implementation that wraps an SQLite database, allowing MCP clients to interact with SQLite via a standardized JSON‑RPC protocol.
MCP SQLite Server is a robust implementation designed to facilitate interaction between MCP clients and SQLite databases using a JSON-RPC protocol. Developed in Go, this server allows for seamless execution of database operations such as creating tables, describing schemas, and executing queries. It is particularly useful for applications like Claude Desktop, which require a standardized protocol for database interactions. The server can be deployed using Docker for ease of use, or built and run directly from source using Go. Configuration is flexible, allowing for customization via YAML files or environment variables. Logging is carefully managed to ensure that protocol communications are not disrupted, especially when using stdio transport.
Features
- MCP Compliance: Provides a JSON‑RPC based interface for tool execution according to the MCP specification.
- SQLite Operations: Supports operations such as creating tables, describing table schemas, listing tables, and executing both read and write queries.
Tools
create_table
Executes a CREATE TABLE statement.
describe_table
Retrieves schema details for a specific table.
list_tables
Returns a list of all tables in the SQLite database.
read_query
Executes SELECT queries and returns the result in JSON format.
write_query
Executes write queries such as INSERT, UPDATE, or DELETE.
