Bun SQLite

Create tables and execute prepared statements in SQLite via Bun.js.

16|1|Updated Apr 7, 2025
One-click install
npx skills add https://github.com/henryoman/TrenchClaw --skill bun-sqlite
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Bun SQLite
Source: https://github.com/henryoman/TrenchClaw/tree/main/.agents/skills/bun-sqlite
Command: npx skills add https://github.com/henryoman/TrenchClaw --skill bun-sqlite

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a streamlined way to interact with SQLite databases directly within a Bun.js environment, simplifying database operations for developers.

Core Features & Use Cases

  • Database Operations: Create, query, update, and delete data in SQLite databases.
  • Prepared Statements & Transactions: Supports efficient and secure data manipulation.
  • Use Case: Quickly set up a local database for a web application, manage user data, or perform complex data analysis tasks using Bun's high-performance runtime.

Quick Start

Use the Bun SQLite skill to create a table named 'users' with 'id' and 'name' columns.

Frequently Asked Questions about Bun SQLite

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

FAQPage Schema
How do I manage SQLite databases using Bun.js?

You can manage SQLite databases using Bun.js by utilizing the built-in `bun:sqlite` module to create tables, execute prepared statements, and manage transactions for efficient data handling within the high-performance Bun runtime.

What query methods are available for SQLite data retrieval in Bun?

SQLite data retrieval in Bun supports get, all, values, and iterate query methods. These provide flexible options to fetch and manipulate records directly from the database using prepared statements.

Does Bun.js have built-in support for SQLite transactions?

Yes, Bun.js supports SQLite transactions natively through the `bun:sqlite` module, allowing developers to group multiple database operations into secure, efficient transactions for reliable data manipulation.

How do I create tables and execute prepared statements in Bun SQLite?

You create tables and execute prepared statements in Bun SQLite by interfacing with the `bun:sqlite` module, streamlining local database setup for web applications and simplifying complex data analysis tasks.

Do I need external dependencies to run SQLite operations in Bun?

No external dependencies are required to run SQLite operations in Bun. The Skill leverages the Bun.js built-in `bun:sqlite` module directly, simplifying environment setup and facilitating immediate database querying.