SQLite Features
- •SQL query execution
- •Table creation and management
- •Schema inspection
- •Business insights generation
- •Continuous memo updates
- •Interactive demonstration mode
- •Automatic sample data generation
SQLite Setup & Configuration
Requirements
- •UV package manager or Docker
- •Claude Desktop
- •SQLite database file
Installation Instructions
# UV Installation
uv run mcp-server-sqlite --db-path ~/test.db
# Docker Installation
docker build -t mcp/sqlite .
docker run --rm -i -v mcp-test:/mcp mcp/sqlite --db-path /mcp/test.db
Configuration
# UV Configuration
{
"mcpServers": {
"sqlite": {
"command": "uv",
"args": [
"--directory",
"parent_of_servers_repo/servers/src/sqlite",
"run",
"mcp-server-sqlite",
"--db-path",
"~/test.db"
]
}
}
}
# Docker Configuration
{
"mcpServers": {
"sqlite": {
"command": "docker",
"args": [
"run",
"--rm",
"-i",
"-v",
"mcp-test:/mcp",
"mcp/sqlite",
"--db-path",
"/mcp/test.db"
]
}
}
}
SQLite Available Tools
- •
read_query
- •
write_query
- •
create_table
- •
list_tables
- •
describe-table
- •
append_insight
SQLite Required Inputs
query
- Type
- string
- Description
- SQL query to execute
- Required
- Yes
table_name
- Type
- string
- Description
- Name of table for schema operations
- Required
- No
insight
- Type
- string
- Description
- Business insight to append to memo
- Required
- No
SQLite Use Cases
- •Database querying and analysis
- •Schema management
- •Business intelligence
- •Data exploration
- •Automated insights generation
- •Database administration
- •Sample data testing
Frequently Asked Questions
A Model Context Protocol server implementation that provides database interaction and business intelligence capabilities through SQLite. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.
UV package manager or Docker, Claude Desktop, SQLite database fileView detailed requirements
Follow the installation instructions in the setup section above.View installation guide
SQLite MCP provides the following tools:
- •
read_query
- •
write_query
- •
create_table
- •
list_tables
- •
describe-table
- •
append_insight