skills.rest
L3DigitalNet
L3DigitalNetOFFICIAL
Explore all skills by this author →
WebsiteGitHub

sqlite

Administer SQLite databases with queries, schema inspection, import/export, backups, and PRAGMA tuning.

6|1|Updated Feb 16, 2026
Search Tags:#database#sqlite#backup#sql#administration#querying
One-click install
npx skills add https://github.com/L3DigitalNet/Claude-Code-Plugins --skill sqlite-l3digitalnet
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlite
Source: https://github.com/L3DigitalNet/Claude-Code-Plugins/tree/main/plugins/linux-sysadmin/skills/sqlite
Command: npx skills add https://github.com/L3DigitalNet/Claude-Code-Plugins --skill sqlite-l3digitalnet

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill simplifies the management and querying of SQLite databases, enabling efficient interaction with single-file databases without complex setup.

Core Features & Use Cases

  • Database Operations: Open, query, import, export, and back up SQLite database files.
  • Schema Inspection: Easily view table structures, columns, and constraints.
  • Performance Tuning: Apply PRAGMA settings for optimal performance and configure WAL mode.
  • Use Case: Quickly inspect the schema of a SQLite database file, export its contents to CSV, and perform an integrity check to ensure data consistency.

Quick Start

Use the sqlite skill to open the database file 'app.db' and list all tables.

Frequently Asked Questions about sqlite

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

FAQPage Schema
How do I view the schema of a SQLite database file?▼

Schema inspection features let you view SQLite database table structures, columns, and constraints directly. This provides comprehensive administration for single-file embedded databases without needing complex setup.

What is the best way to back up a SQLite database?▼

The best way to back up a SQLite database is using dedicated backup operations. This skill simplifies management by enabling efficient backup operations and data export for single-file databases.

How do I configure WAL mode and apply PRAGMA tuning for a SQLite database?▼

You configure WAL mode and apply PRAGMA settings for a SQLite database through performance tuning features. This ensures optimal database performance and configures write-ahead logging.

Can I export SQLite database contents to CSV?▼

Yes, you can export SQLite database contents to CSV. Data import and export operations are fully supported, enabling efficient interaction with single-file embedded databases.

Why does my SQLite database locking prevent queries, and how do I fix it?▼

SQLite database locking prevents concurrent queries by locking the file. You can resolve this by configuring WAL mode to allow concurrent reads and writes during database operations.

Related Skills

Explore More Software Engineering Skills→
cc01cccc01cc
4

sqlite-reader

Explore SQLite databases read-only via the sqlite3 CLI.

Community
Intermediate
BirdywenBirdywen
1

sqlite-data

Create, query, analyze, and export SQLite data via the sqlite3 CLI.

Community
Intermediate
partme-aipartme-ai
610

dbeaver

Guide DBeaver database connections, SQL queries, data management, and administration.

Official
Basic
xlelibertyxleliberty

sql-database-assistant

Generate SQL queries and analyze execution plans across PostgreSQL, MySQL, SQLite, and SQL Server.

Community
Advanced