Bun Sqlite

What it does

The Bun Sqlite skill allows an AI agent to interact with SQLite databases using Bun, a fast JavaScript runtime. It enables creating, opening, querying, and manipulating SQLite databases directly within SecondSky. The skill provides functionality for executing SQL statements (like CREATE TABLE, INSERT, UPDATE, DELETE) and retrieving data from tables.

When to use it

• You need to store and retrieve structured data persistently.
• You want to perform database operations as part of an automated workflow.
• You're working with existing SQLite databases that you need to query or update programmatically.
• You require a fast and efficient way to manage small to medium-sized datasets.

Key capabilities

• Database Creation/Opening: Create new SQLite databases or open existing ones, including in-memory databases.
• SQL Execution: Execute SQL statements for data definition (DDL) and data manipulation (DML).
• Prepared Statements: Utilize prepared statements for efficient query execution with parameters.
• Data Retrieval: Retrieve data using methods like .get() (first row), .all() (all rows), and iterating through results.
• Parameter Handling: Support positional, array, and named parameters in SQL queries.

Example prompts

• "Create a table called 'products' with columns for id, name, and price."
• "Insert a new product into the 'products' table: name = 'Laptop', price = 1200."
• "Select all users from the 'users' table where the email address ends with '@example.com'."

Tips & gotchas

• The skill utilizes Bun’s built-in SQLite driver, so familiarity with SQL syntax is required.
• For optimal performance and data integrity, use prepared statements whenever possible.
• Be mindful of database file paths when creating or opening databases.