How do I prevent SQL injection using this skill?

The skill emphasizes the use of prepared statements via the db.prepare() method and parameter binding with '?' placeholders instead of string interpolation.

What makes Bun's SQLite driver different?

Bun includes a built-in, highly optimized SQLite driver that is significantly faster than traditional Node.js alternatives like better-sqlite3 because it is integrated directly into the runtime.

Can I use this for in-memory databases?

Yes, you can initialize a database in memory by passing ':memory:' to the Database constructor, which is ideal for high-speed testing and temporary caching.

Does this skill help with database migrations?

Yes, it includes common patterns for setting up migration tracking tables and applying versioned SQL updates to your database schema safely within transactions.

How are transactions handled in Bun SQLite?

Bun provides a db.transaction() method that wraps a function; if any error occurs during execution, the transaction is automatically rolled back to maintain data integrity.

Bun SQLite Management

Name: Bun SQLite Management
Author: TheBushidoCollective

byTheBushidoCollective

•

データベース管理

Optimizes SQLite database operations using Bun's native high-performance driver for efficient data storage and retrieval.

概要

This skill empowers Claude with specialized knowledge of Bun's built-in SQLite driver, enabling the creation of high-performance database solutions within the Bun runtime. It provides guidance on opening databases (including in-memory and read-only modes), executing optimized queries, utilizing prepared statements to prevent SQL injection, and managing atomic transactions. By leveraging this skill, developers can implement robust CRUD operations, handle migrations, and apply best practices for database resource management in Bun-based applications without needing external dependencies.

主な機能

Native Bun SQLite driver implementation
Database migration and schema versioning strategies
Advanced CRUD patterns and repository structures
39 GitHub stars
Atomic transaction management with automatic rollback
High-performance prepared statements

ユースケース

Building fast, local-first data storage for Bun applications
Managing in-memory databases for high-speed testing environments
Implementing lightweight persistent storage for CLI tools

概要

主な機能

Native Bun SQLite driver implementation
Database migration and schema versioning strategies
Advanced CRUD patterns and repository structures
39 GitHub stars
Atomic transaction management with automatic rollback
High-performance prepared statements

ユースケース

Building fast, local-first data storage for Bun applications
Managing in-memory databases for high-speed testing environments
Implementing lightweight persistent storage for CLI tools