Sqlmodel Orm Dbhelper

What it does

This skill provides access to SQLAlchemy ORM and database helper functions for interacting with relational databases. It allows AI agents to execute SQL queries, manage database connections, and perform common database operations like creating tables, inserting data, and retrieving information. The skill simplifies complex database interactions by providing a higher-level abstraction layer.

When to use it

• Data Extraction: Retrieve specific data points from a database based on user requests (e.g., "Get me all customers in California").
• Database Management: Create new tables or modify existing ones within the database, allowing for dynamic schema changes.
• Automated Reporting: Generate reports by querying and aggregating data stored in a relational database.
• Data Updates: Update records in a database based on user instructions (e.g., "Change John Doe's address to 123 Main St.").

Key capabilities

• SQLAlchemy ORM integration
• Database connection management
• SQL query execution
• Table creation and modification
• Data insertion, retrieval, and updating

Example prompts

• "Create a table named 'users' with columns for id, name, and email."
• "Retrieve all records from the 'products' table where the price is greater than $50."
• "Update the 'orders' table to mark order ID 123 as shipped."

Tips & gotchas

• Requires a configured database connection. Ensure that the necessary credentials and connection details are provided for proper functionality.
• The agent needs appropriate permissions on the target database to execute queries and make changes.