Sqlite Database Expert

What it does

This skill enables an AI agent to interact with SQLite databases, including creating tables, querying data, and performing CRUD operations. It supports writing SQL statements, interpreting query results, and handling common database management tasks.

When to use it

• You need to extract or manipulate data stored in a local SQLite file.
• You're developing an application that requires lightweight, embedded database functionality.
• You want to automate data analysis workflows using SQL queries on structured datasets.
• You are troubleshooting or debugging issues with an existing SQLite database.

Key capabilities

• Execute SQL queries (SELECT, INSERT, UPDATE, DELETE).
• Create and manage tables and indexes.
• Handle transactions and constraints.
• Parse and return query results in structured formats.

Example prompts

• "Run a SELECT * FROM users WHERE age > 30 on the database file 'data.db'."
• "Create a new table called 'orders' with columns id, product_name, and quantity."
• "Export all records from the 'logs' table to a CSV file."

Tips & gotchas

• Ensure the SQLite file path is correct and accessible to the AI agent.
• Be cautious when running DELETE or UPDATE queries without proper WHERE clauses to avoid unintended data loss.