22-tool SQLite DBA toolkit via litescope (npx) — schema diff, migration planning, lint/advise, health checks, snapshots, autopilot, lock diagnosis

{
  "server": "litescope",
  "version": "0.6.6",
  "install": "npm install litescope",
  "entry": "litescope mcp [--allow-writes]",
  "transport": "stdio",
  "binary": "Go (compiled, zero deps)",
  "tools": 22,
  "calls": 20,
  "success_rate": "95% (19 OK + 1 correct rejection)",
  "p50_ms": 1,
  "max_ms": 14,
  "tool_categories": {
    "schema_inspection": 3,
    "migration": 3,
    "health_diagnostics": 4,
    "automation": 2,
    "snapshots": 3,
    "cloudflare_d1": 4,
    "fleet": 2,
    "time_travel": 1
  },
  "traces": [
    {
      "tool": "litescope_health",
      "args": {
        "source": "test-a.db"
      },
      "ms": 14,
      "result": "severity:ok, integrity:true, 16KB"
    },
    {
      "tool": "litescope_schema",
      "args": {
        "source": "test-a.db"
      },
      "ms": 1,
      "result": "2 tables: users(4 cols), orders(3 cols)"
    },
    {
      "tool": "litescope_diff",
      "args": {
        "old": "test-a.db",
        "new": "test-b.db"
      },
      "ms": 1,
      "result": "users+age col, orders+status col, +1 row each"
    },
    {
      "tool": "litescope_migrate_plan",
      "args": {
        "old": "test-a.db",
        "new": "test-b.db"
      },
      "ms": 1,
      "result": "2 safe ADD COLUMN ops, metadata-only, instant"
    },
    {
      "tool": "litescope_migrate_diff",
      "args": {
        "old": "test-a.db",
        "new": "test-b.db"
      },
      "ms": 1,
      "result": "ALTER TABLE orders ADD COLUMN status; ALTER TABLE users ADD COLUMN age"
    },
    {
      "tool": "litescope_query",
      "args": {
        "source": "test-b.db",
        "sql": "SELECT u.name,o.amount,o.status FROM users u JOIN orders o ON u.id=o.user_id"
      },
      "ms": 1,
      "result": "3 rows with join data"
    },
    {
      "tool": "litescope_advise",
      "args": {
        "source": "test-a.db",
        "queries": ["SELECT * FROM orders WHERE user_id=1"]
      },
      "ms": 1,
      "result": "fk-no-index warning + full-scan + CREATE INDEX suggestion"
    },
    {
      "tool": "litescope_locks",
      "args": {
        "source": "test-a.db"
      },
      "ms": 1,
      "result": "CRITICAL: journal-not-wal"
    },
    {
      "tool": "litescope_autopilot",
      "args": {
        "source": "test-a.db",
        "apply": false
      },
      "ms": 0,
      "result": "2 safe actions: ANALYZE + PRAGMA optimize"
    },
    {
      "tool": "litescope_snapshot",
      "args": {
        "source": "test-a.db",
        "label": "pathfinder-test"
      },
      "ms": 1,
      "result": "snapshot created, 16KB, integrity-checked"
    }
  ]
}