Home Tutorials Categories Skills About
ZH EN JA KO
📦

SQLite

Database Database & Storage

Install Command

npx clawhub@latest install sqlite

Installation Guide

1
Check Environment

Make sure Node.js 22+ and OpenClaw are installed. Run openclaw --version in your terminal to verify.

2
Run Installation

Run the install command above in your terminal. ClawHub will automatically download and install SQLite to the ~/.openclaw/skills/ directory.

3
Verify Installation

Run openclaw skills list to check your installed skills and confirm SQLite appears in the list.

4
Configure (Optional)

Follow the configuration instructions in the description below to add skill settings to ~/.config/openclaw/openclaw.json5.

Manual Installation: Copy the Skill folder to ~/.openclaw/skills/ or the skills/ directory in your project root. Make sure the folder contains a SKILL.md file.
Local Database Zero Configuration File Queries

Detailed Description

The SQLite skill lets OpenClaw directly read and query local SQLite database files without any server configuration.

Core Features

  • File Reading: Directly open .db, .sqlite, and .sqlite3 files
  • SQL Queries: Execute SQL queries with formatted result display
  • Table Structure: View all tables and field definitions in the database
  • Data Export: Export query results to CSV or JSON
  • Multi-File Support: Query multiple SQLite files simultaneously

Configuration

{
  skills: {
    sqlite: {
      defaultPath: "~/databases/",
      readOnly: true
    }
  }
}

Use Cases

  • Analyze iOS/Android application local databases
  • Query browser history (Chrome uses SQLite for storage)
  • Analyze Python application SQLite data
  • Quickly inspect embedded system database contents