sqlite-anet-mcp
If you are the rightful owner of sqlite-anet-mcp 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.
A Rust implementation of the Model Control Protocol (MCP) server that provides SQLite database capabilities via a standardized protocol.
The SQLite-Anet-MCP Server is a Rust-based implementation of the Model Control Protocol (MCP) server, designed to facilitate AI agents in creating, managing, and querying SQLite databases directly. This server leverages the NATS transport layer for efficient message passing and supports JSON-RPC 2.0 for API compatibility. It is built to handle asynchronous requests using Tokio, ensuring high performance and scalability. The server allows for the execution of various SQL operations, including SELECT, INSERT, UPDATE, and DELETE queries, and provides tools for describing table schemas and listing available tables. Additionally, it includes features for saving and synthesizing business insights from data, making it a versatile tool for data-driven applications.
Features
- Create and manage SQLite database tables
- Execute SELECT queries for data retrieval
- Execute INSERT, UPDATE, and DELETE queries for data manipulation
- Describe table schemas and list available tables
- NATS transport layer for message passing
Tools
list_tables
List all tables in the SQLite database.
describe_table
Get the schema information for a specific table.
create_table
Create a new table in the SQLite database.
read_query
Execute a SELECT query on the SQLite database.
write_query
Execute an INSERT, UPDATE, or DELETE query on the SQLite database.
append_insight
Add a business insight to the memo.
