jutsu-bun:bun-sqlite

Manage SQLite databases in Bun with prepared statements and transactions.

187|20|Updated Nov 20, 2025
One-click install
npx skills add https://github.com/TheBushidoCollective/han --skill jutsu-bun-bun-sqlite
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: jutsu-bun:bun-sqlite
Source: https://github.com/TheBushidoCollective/han/tree/main/jutsu/jutsu-bun/skills/bun-sqlite
Command: npx skills add https://github.com/TheBushidoCollective/han --skill jutsu-bun-bun-sqlite

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill covers Bun's built-in SQLite driver, including prepared statements and transactions for efficient data handling.

Core Features & Use Cases

  • Open & Query: Create or open SQLite databases and run queries.
  • Prepared Statements: Use prepared statements for performance and safety.
  • Transactions: Atomic operations with rollback on error.

Quick Start

Create a SQLite database, prepare an insert, and run a transaction to insert multiple rows.

Frequently Asked Questions about jutsu-bun:bun-sqlite

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

FAQPage Schema
How do I execute SQL queries on a SQLite database in Bun?

Bun's built-in bun:sqlite driver lets you execute SQL queries directly on SQLite databases. Use methods like .run(), .query(), .all(), .get(), or .values() to execute statements and retrieve results with full error handling support.

What are prepared statements and why use them with SQLite?

Prepared statements are pre-compiled SQL queries that separate code from data, preventing SQL injection and improving performance. Bun's sqlite driver supports prepared statements for safe, efficient repeated query execution.

How do I handle transactions and rollbacks in Bun SQLite?

Transactions enable atomic operations—multiple queries execute together or fail together. Bun's sqlite driver supports transaction control with automatic rollback on error, ensuring data consistency for multi-step operations.

Can I perform CRUD operations with Bun's SQLite driver?

Yes. Bun's native bun:sqlite driver supports full CRUD operations—create, read, update, delete—using prepared statements and transaction support with comprehensive error handling throughout.

Does Bun's SQLite driver work for high-performance database operations?

Yes. Bun's built-in sqlite driver is optimized for high-performance database management, offering efficient prepared statements, transaction support, and native query methods designed for speed and safety.