SQLite MCP Server

MCP server for SQLite database interaction and business intelligence. Enables AI agents to query SQLite databases, create and modify tables, run analytical queries, and generate insights from data. Supports read-write operations with transaction safety and provides schema introspection for understanding database structure.

{
  "mcpServers": {
    "sqlite": {
      "command": "uvx",
      "args": [
        "mcp-server-sqlite",
        "--db-path",
        "./database.db"
      ]
    }
  }
}

{
  "type": "object",
  "required": [
    "query"
  ],
  "properties": {
    "query": {
      "type": "string",
      "description": "SQL SELECT query to execute"
    }
  }
}

{
  "type": "object",
  "required": [
    "query"
  ],
  "properties": {
    "query": {
      "type": "string",
      "description": "SQL write query to execute"
    }
  }
}

{
  "type": "object",
  "required": [
    "query"
  ],
  "properties": {
    "query": {
      "type": "string",
      "description": "CREATE TABLE SQL statement"
    }
  }
}

{
  "type": "object",
  "properties": {}
}

{
  "type": "object",
  "required": [
    "table_name"
  ],
  "properties": {
    "table_name": {
      "type": "string",
      "description": "Name of the table to describe"
    }
  }
}