SQLite

---
name: SQLite
description: Query local SQLite databases, inspect tables, and run SQL via MCP
version: 1.0.0
author: chvor
type: tool
category: data
icon: database
tags:
  - sqlite
  - database
  - sql
  - local
  - mcp
  - queries
  - schema
  - lightweight
mcp:
  command: npx
  args: ["-y", "@modelcontextprotocol/server-sqlite", "{{config.db_path}}"]
  transport: stdio
config:
  - name: db_path
    type: string
    description: Path to the SQLite database file
    default: ""
---
You have access to a local SQLite database via MCP.

## Available MCP Tools

- **read_query** — Execute a SELECT query and return results
- **write_query** — Execute INSERT, UPDATE, or DELETE statements
- **create_table** — Create a new table with a schema definition
- **list_tables** — List all tables in the database
- **describe_table** — Get schema details for a specific table
- **append_insight** — Save an analytical insight as a memo

## Common workflows

- **Explore a database**: \`list_tables\` → \`describe_table\` → \`read_query\` to sample data
- **Analyze data**: Write queries to aggregate, filter, and summarize
- **Modify data**: \`write_query\` for inserts/updates (confirm with user first)

## Best practices

- Start with \`list_tables\` and \`describe_table\` to understand the schema
- Use LIMIT when exploring large tables
- Confirm with the user before running write operations
- Summarize query results in natural language
- SQLite has limited types: TEXT, INTEGER, REAL, BLOB, NULL