sqlite

Query and modify local SQLite databases, including encrypted sqlcipher files.

1|Updated Mar 13, 2026
One-click install
npx skills add https://github.com/kkbig509/weclaw --skill sqlite-kkbig509
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sqlite
Source: https://github.com/kkbig509/weclaw/tree/main/src/weclaw/skills/sqlite
Command: npx skills add https://github.com/kkbig509/weclaw --skill sqlite-kkbig509

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill allows you to interact with local SQLite database files, enabling you to query data, inspect schemas, and execute modification statements, even for encrypted databases.

Core Features & Use Cases

  • Database Inspection: View table schemas and list all tables within a database.
  • Data Querying: Execute SQL SELECT statements to retrieve specific data.
  • Data Modification: Perform INSERT, UPDATE, and DELETE operations.
  • Encryption Management: Handle encrypted databases by providing passwords and even rekeying or removing passwords.
  • Use Case: You need to quickly check the user list in your local app.db file, or perhaps update a user's status. This skill lets you do that directly from the command line.

Quick Start

List all tables in the file /path/to/app.db.

Frequently Asked Questions about sqlite

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query data from a local SQLite database file?

You can query local SQLite databases by executing SQL SELECT statements to retrieve specific data. This skill supports direct data retrieval and schema inspection from your .db files.

Can I modify SQLite database records using INSERT, UPDATE, and DELETE statements?

Yes, you can modify SQLite database records using INSERT, UPDATE, and DELETE statements. The skill enables direct data manipulation within your local database files.

How do I inspect table schemas in an SQLite database?

You can inspect SQLite table schemas by listing all tables within a database file. This enables quick viewing of the database structure before running queries.

Does this work with encrypted databases using sqlcipher?

Yes, it works with encrypted databases using sqlcipher. You can provide passwords to decrypt databases, manage existing passwords, and perform rekeying operations.

How do I remove or change the password on an encrypted SQLite database?

You can remove or change the password on an encrypted SQLite database by using the rekeying and decryption management features. This supports direct password removal and updates for sqlcipher files.