Loading connector details…
MCP SQLite Demo
MCPOpen SourceMIT10.0
by Resources-cskwork • Data & Databases
A demo MCP server that lets Claude Desktop connect to a local SQLite database for testing and querying data like products and prices.
Example Use Cases
- 1
Connect to and query a local SQLite database (e.g., retrieve product lists and prices) from Claude Desktop.
- 2
A simple MCP server example to test integration, configuration, and end-to-end request handling with Claude Desktop on macOS or Windows.
- 3
A reproducible development environment to prototype MCP-based database access patterns before implementing a production server.
Description
This repository demonstrates the Model Context Protocol (MCP) with a SQLite backend, providing a runnable example for connecting Claude Desktop to a local SQLite database. It includes setup instructions, required prerequisites (uv, Git, SQLite), a script to create the sample database, and example Claude Desktop configuration for registering the MCP server. The project is intended for testing, learning, and local development rather than production deployment.
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
C63/100
9/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
OwnerResources-cskwork
CategoryData & Databases
DependenciesStandalone
Tags
DatabaseLocalTestingPrototype