SQLite MCP Server
by jacksteamdev
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| mcp-demo | a demo prompt for SQLite MCP Server |
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 read-only SQL query |
| write-query | Execute a write SQL query |
| create-table | Create a new table in the database |
| list-tables | List all tables in the database |
| describe-table | Get schema information for a table |
| append-insight | Add a business insight to the memo |