SQLite

MCP server for querying SQLite databases. Lightweight local database access for prototyping, small datasets, application databases, and analytics on local data files. No server setup needed — just point at a .db file.

Useful for querying application databases (many apps use SQLite), analyzing exported datasets, prototyping data models, and working with local data that doesn't need a full database server.

Install

amodal install mcp sqlite

Tools exposed

• query — Execute a SQL query and return results as JSON rows. SELECT queries run directly. INSERT/UPDATE/DELETE require confirmation. Supports parameterized queries with ? placeholders.
• describe_table — Return column names, types, nullability, defaults, and primary key info for a table.
• list_tables — List all tables in the database with row counts and creation SQL.
• create_table — Create a new table with specified columns and types (confirmation required).
• export_query — Run a query and return results as CSV. Useful for piping data to other tools or files.
• get_schema — Return the full database schema as SQL CREATE statements.

Configuration

env:
  SQLITE_DB_PATH: "/path/to/database.db"

• SQLITE_DB_PATH — Path to the SQLite database file. Creates the file if it doesn't exist. Required.
• SQLITE_READ_ONLY — Set to true to open the database in read-only mode. Defaults to false.

Example usage

• "Show me the schema of the analytics.db database"
• "How many events were recorded per day this week?"
• "Find all users who signed up but never completed onboarding"
• "Create a new table to track the experiment results we've been collecting"