Grdb

What it does

This skill enables AI agents to interact with SQLite databases using GRDB, a powerful Swift library. It allows agents to execute complex SQL queries, manage database schemas, and persist data directly within Swift applications without manual coding.

When to use it

• You need an agent to store user preferences or session state in a local SQLite file.
• Your project requires complex relational queries that standard JSON storage cannot handle efficiently.
• You are building a native iOS or macOS application and want the AI to manage data integrity automatically.
• You require rapid prototyping of database logic without writing boilerplate Swift code.

Key capabilities

• Executes raw SQL statements for data retrieval and manipulation.
• Manages database schema creation and migrations dynamically.
• Handles connection pooling and transaction management securely.
• Supports complex joins, aggregations, and filtering within SQLite.

Example prompts

• "Create a new table called 'users' with columns for id, name, and email, then insert three sample records."
• "Write a query to find all users who have made more than 5 purchases in the last month."
• "Update the status of all pending orders to 'shipped' and log the number of rows affected."

Tips & gotchas

Ensure your AI agent has read/write access to the target SQLite file path, as local permissions can block database operations. Be cautious with dynamic SQL generation; always validate inputs to prevent injection attacks when handling untrusted data sources.