SQLite

Connect HolmesGPT to SQLite databases to analyze query performance, examine table schemas, check index usage, and read data for troubleshooting local databases.

You can configure multiple SQLite instances with different names (e.g., dev-sqlite, test-sqlite, app-cache-sqlite).

File Permissions

Ensure the database file is accessible:

# Make database readable
chmod 644 /path/to/database.db

# If Holmes runs as specific user, ensure ownership
chown holmes:holmes /path/to/database.db

# Or use group access
chmod 664 /path/to/database.db
chgrp holmes-group /path/to/database.db

Configuration

Holmes CLIHolmes Helm ChartRobusta Helm Chart

~/.holmes/config.yaml:

toolsets:
  dev-sqlite:
    type: database
    config:
      connection_url: "sqlite:////absolute/path/to/database.db"
    llm_instructions: "Local development database with test data"

  app-cache-sqlite:
    type: database
    config:
      connection_url: "sqlite:////var/lib/app/cache.db"
    llm_instructions: "Application cache database"

Connection URL format:

sqlite:///[absolute_path_to_file]

Important: Use four slashes (////) for absolute paths: - sqlite:////home/user/app.db - Absolute path on Linux/Mac - sqlite:////var/lib/app/data.db - Another Linux example

In-memory database (testing only):

connection_url: "sqlite:///:memory:"

Using mounted volume:

extraVolumes:
  - name: sqlite-db
    hostPath:
      path: /path/on/host/database.db
      type: File

extraVolumeMounts:
  - name: sqlite-db
    mountPath: /data/database.db
    readOnly: true

toolsets:
  app-sqlite:
    type: database
    config:
      connection_url: "sqlite:////data/database.db"
    llm_instructions: "Application database mounted from host"

Multiple instances:

extraVolumes:
  - name: app-db
    hostPath:
      path: /data/app.db
      type: File
  - name: cache-db
    hostPath:
      path: /data/cache.db
      type: File

extraVolumeMounts:
  - name: app-db
    mountPath: /data/app.db
    readOnly: true
  - name: cache-db
    mountPath: /data/cache.db
    readOnly: true

toolsets:
  app-sqlite:
    type: database
    config:
      connection_url: "sqlite:////data/app.db"

  cache-sqlite:
    type: database
    config:
      connection_url: "sqlite:////data/cache.db"

Using mounted volume:

holmes:
  extraVolumes:
    - name: sqlite-db
      hostPath:
        path: /path/on/host/database.db
        type: File

  extraVolumeMounts:
    - name: sqlite-db
      mountPath: /data/database.db
      readOnly: true

  toolsets:
    app-sqlite:
      type: database
      config:
        connection_url: "sqlite:////data/database.db"
      llm_instructions: "Application database mounted from host"

Multiple instances:

holmes:
  extraVolumes:
    - name: app-db
      hostPath:
        path: /data/app.db
        type: File
    - name: cache-db
      hostPath:
        path: /data/cache.db
        type: File

  extraVolumeMounts:
    - name: app-db
      mountPath: /data/app.db
      readOnly: true
    - name: cache-db
      mountPath: /data/cache.db
      readOnly: true

  toolsets:
    app-sqlite:
      type: database
      config:
        connection_url: "sqlite:////data/app.db"

    cache-sqlite:
      type: database
      config:
        connection_url: "sqlite:////data/cache.db"

Configuration Options

• connection_url (required): SQLite connection URL
• read_only (default: true): Only allow SELECT/SHOW/DESCRIBE/EXPLAIN/WITH statements
• max_rows (default: 200): Maximum rows to return (1-10000)
• llm_instructions: Context about this database

Common Use Cases

"Show all tables and their row counts"

"Analyze query: SELECT * FROM users WHERE email LIKE '%@example.com'"

"Suggest indexes for the orders table"