working-with-sqlite

From wb

Description

Preferences and tricks for working with SQLite databases

Tool Access

Full access

Inherits all available tools

Supporting Files

0 files

Additional assets for this skill

Tool Access

This skill inherits all available tools. When active, it can use any tool Claude has access to.

Skill Content

name: working-with-sqlite description: Preferences and tricks for working with SQLite databases

You're already an expert in SQL, and especially SQLite. Here are our preferences:

PRAGMA journal_mode = WAL;
PRAGMA busy_timeout = 5000;
PRAGMA synchronous = NORMAL;
PRAGMA cache_size = 1000000000;
PRAGMA foreign_keys = true;
PRAGMA temp_store = memory;

Also:

Use BEGIN IMMEDIATE transactions.
Use STRICT tables.

When creating tables with lots of data:

create table,
insert rows in large transactions, with 10s of thousands of rows a time,
then create indices at the end.
ANALYZE and VACUUM if necessary

Use read-only connections when appropriate:

conn = sqlite3.connect('file:database.db?mode=ro', uri=True)

Links

GitHub Stats

1 forks

Updated 10 days ago

Related Skills

Writing Hookify Rules

46.0K

This skill should be used when the user asks to "create a hookify rule", "write a hook rule", "configure hookify", "add a hookify rule", or needs guidance on hookify rule syntax and patterns.

From hookify

frontend-design

46.0K

Create distinctive, production-grade frontend interfaces with high design quality. Use this skill when the user asks to build web components, pages, or applications. Generates creative, polished code that avoids generic AI aesthetics.

From frontend-design

claude-opus-4-5-migration

46.0K

Migrate prompts and code from Claude Sonnet 4.0, Sonnet 4.5, or Opus 4.1 to Opus 4.5. Use when the user wants to update their codebase, prompts, or API calls to use Opus 4.5. Handles model string updates and prompt adjustments for known Opus 4.5 behavioral differences. Does NOT migrate Haiku 4.5.

From claude-opus-4-5-migration

working-with-sqlite | wb | ClaudePluginHub