Does this skill require installing separate SQLite drivers?

No, it utilizes Bun's native `bun:sqlite` module, which is built into the runtime and offers significantly higher performance than traditional Node.js drivers.

Can I use this for in-memory databases?

Yes, the skill includes specific patterns for initializing and managing `:memory:` databases, which are ideal for automated testing and temporary data processing.

How are transactions handled in this skill?

It uses Bun's `db.transaction()` method, which provides high-performance atomic operations with automatic rollback functionality if an error occurs during execution.

How does the Bun SQLite skill handle security?

The skill enforces the use of prepared statements and parameterized queries by default to protect your application against SQL injection vulnerabilities.

Does it support complex database migrations?

Yes, it provides a standardized migration pattern that tracks applied changes in a dedicated table to ensure schema consistency across environments.

Bun SQLite

Name: Bun SQLite
Author: TheBushidoCollective

byTheBushidoCollective

•

Database Management

Manages high-performance SQLite database operations using Bun's native driver for seamless data persistence and optimized queries.

About

The Bun SQLite skill empowers Claude to leverage Bun's built-in, ultra-fast SQLite engine to build robust data-driven applications. It provides expert guidance on implementing type-safe CRUD operations, managing complex transactions with automatic rollbacks, and utilizing prepared statements for maximum performance and security. Whether setting up migrations, designing repository patterns, or optimizing query performance, this skill ensures that database logic in Bun environments follows industry-standard best practices for ethical and professional software development.

Key Features

Automated implementation of prepared statements to prevent SQL injection
Native high-performance SQLite integration with zero external dependencies
Structured repository and query builder patterns for maintainable code
72 GitHub stars
Comprehensive migration systems for version-controlled schema updates
Efficient transaction management for atomic and reliable data operations

Use Cases

Implementing structured state management and caching for high-performance backends
Building local data persistence for Bun-based CLI tools or edge applications
Creating versioned database schemas and migrations for evolving TypeScript projects

About

Key Features

Automated implementation of prepared statements to prevent SQL injection
Native high-performance SQLite integration with zero external dependencies
Structured repository and query builder patterns for maintainable code
72 GitHub stars
Comprehensive migration systems for version-controlled schema updates
Efficient transaction management for atomic and reliable data operations

Use Cases

Implementing structured state management and caching for high-performance backends
Building local data persistence for Bun-based CLI tools or edge applications
Creating versioned database schemas and migrations for evolving TypeScript projects