Loading connector details…
SQLite MCP Server
MCPOpen Source16.0
by 8LWXpg • Data & Databases
An MCP server that exposes SQLite database access and automated business-insight memo generation for agents and BI workflows.
Example Use Cases
- 1
Execute read and write SQL queries against a SQLite database through an MCP interface.
- 2
Inspect and modify database schemas and list or describe tables programmatically.
- 3
Generate, append, and continuously maintain a shared business-insights memo derived from data analysis.
Description
This server implements a Model Context Protocol (MCP) interface to a SQLite database, providing tools to run SELECT/INSERT/UPDATE/DELETE queries, create tables, and inspect schemas. It includes an interactive demo prompt to generate schemas and sample data and an appendable memo resource (memo://insights) that auto-updates as new business insights are discovered. The README provides usage examples for local (uv) and Docker deployment and the project is distributed under the MIT License.
Capabilities(8 total)
Tools (6)
read_query
Execute a SELECT query on the SQLite database
query:string*
write_query
Execute an INSERT, UPDATE, or DELETE query on the SQLite database
query:string*
create_table
Create a new table in the SQLite database
query:string*
list_tables
List all tables in the SQLite database
describe_table
Get the schema information for a specific table
table_name:string*
Prompts (1)
mcp-demo
A prompt to seed the database with initial data and demonstrate what you can do with an SQLite MCP Server + Claude
topic
Resources (1)
Business Insights Memo
A living document of discovered business insights
URI: memo://insightsMIME: text/plain
Quick Actions
Security
Scanned 2 month(s) agoRisk Level
MODERATE
Can modify files, state, or send data externally
Trust Score
C51/100
5/17 checks passed
Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.
Quick Stats
Service TypeMCP
Pricing ModelFree
Capabilities6 Tools / 1 Prompts / 1 Resources
Owner8LWXpg
CategoryData & Databases
DependenciesStandalone
Tags
DatabaseSQLSQLiteSchemaMemo