SQLite MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| db-path | Yes | Path to the SQLite database file | ~/test.db |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| mcp-demo | A prompt to seed the database with initial data and demonstrate what you can do with an SQLite MCP Server + Claude |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| Business Insights Memo | A living document of discovered business insights |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| read_query | Execute a SELECT query on the SQLite database |
| write_query | Execute an INSERT, UPDATE, or DELETE query on the SQLite database |
| create_table | Create a new table in the SQLite database |
| list_tables | List all tables in the SQLite database |
| describe_table | Get the schema information for a specific table |
| append_insight | Add a business insight to the memo |