SQLite MCP Server

Overview

Components

Resources

• memo://insights

  : A continuously updated business insights memo that aggregates discovered insights during analysis
  • Auto-updates as new insights are discovered via the append-insight tool

Prompts

• mcp-demo

  : Interactive prompt that guides users through database operations
  • Required argument:

    topic

    - The business domain to analyze
  • Generates appropriate database schemas and sample data
  • Guides users through analysis and insight generation
  • Integrates with the business insights memo

Tools

Query Tools

• read_query

  • Execute SELECT queries to read data from the database
  • Input:

    • query

      (string): The SELECT SQL query to execute
  • Returns: Query results as array of objects

• write_query

  • Execute INSERT, UPDATE, or DELETE queries
  • Input:

    • query

      (string): The SQL modification query
  • Returns:

    { affected_rows: number }

• create_table

  • Create new tables in the database
  • Input:

    • query

      (string): CREATE TABLE SQL statement
  • Returns: Confirmation of table creation

Schema Tools

• list_tables

  • Get a list of all tables in the database
  • No input required
  • Returns: Array of table names

• describe-table

  • View schema information for a specific table
  • Input:

    • table_name

      (string): Name of table to describe
  • Returns: Array of column definitions with names and types

Analysis Tools

• append_insight

  • Add new business insights to the memo resource
  • Input:

    • insight

      (string): Business insight discovered from data analysis
  • Returns: Confirmation of insight addition
  • Triggers update of memo://insights resource

Usage with Claude Desktop

uv

# Add the server to your claude_desktop_config.json
"mcpServers": {
  "sqlite": {
    "command": "uv",
    "args": [
      "--directory",
      "parent_of_servers_repo/servers/src/sqlite",
      "run",
      "mcp-server-sqlite",
      "--db-path",
      "~/test.db"
    ]
  }
}

Docker

# Add the server to your claude_desktop_config.json
"mcpServers": {
  "sqlite": {
    "command": "docker",
    "args": [
      "run",
      "--rm",
      "-i",
      "-v",
      "mcp-test:/mcp",
      "mcp/sqlite",
      "--db-path",
      "/mcp/test.db"
    ]
  }
}

Building

docker build -t mcp/sqlite .

Test with MCP inspector

uv add "mcp[cli]"
mcp dev src/mcp_server_sqlite/server.py:wrapper  

License