Axiom Sqlitedata Ref

What it does

This skill allows AI agents to interact with SQLite databases. It provides the ability to execute SQL queries, retrieve data, and manage database connections directly within an agent workflow. The agent can read, write, update, and delete data stored in a local SQLite database file.

When to use it

• Local Data Storage: When your AI agent needs persistent storage for small amounts of data that don't require a full-fledged database server (e.g., storing user preferences).
• Offline Functionality: Enable the agent to access and manipulate data even when an internet connection is unavailable.
• Data Analysis & Reporting: Allow agents to query and summarize data stored in SQLite databases for reporting or analysis tasks.
• Simple Data Management: Automate repetitive database management tasks, such as creating tables or importing data.

Key capabilities

• Execute SQL queries (SELECT, INSERT, UPDATE, DELETE)
• Connect to a specified SQLite database file
• Retrieve data from tables
• Manage database connections

Example prompts

• "Run the query 'SELECT * FROM users WHERE age > 30' against the database 'my_data.db'."
• "Insert a new record into the 'products' table with name='widget', price=19.99."
• "Update the 'orders' table, setting status to 'shipped' for order ID 123."

Tips & gotchas

• Ensure the agent has read/write access to the SQLite database file path specified in the prompt.
• Be mindful of SQL injection vulnerabilities when constructing queries from user input; sanitize inputs appropriately.