Coder Rust Sqlx Queries

What it does

This skill enables AI agents to generate and execute SQL queries using Rust and the sqlx crate. It facilitates database interactions, allowing agents to retrieve, insert, update, or delete data based on natural language instructions. The agent can handle complex queries involving joins, aggregations, and filtering.

When to use it

• Data Extraction: Retrieve specific information from a relational database (e.g., "Get all customers who placed an order in the last month").
• Database Updates: Modify data within a database based on instructions (e.g., "Update the price of product X to Y").
• Report Generation: Create reports by querying and aggregating data from multiple tables (e.g., "Generate a report showing total sales per region").
• Data Migration/Transformation: Perform complex data transformations or migrations between databases.

Key capabilities

• Rust programming language proficiency
• sqlx crate for database interaction
• SQL query generation and execution
• Support for various SQL dialects (PostgreSQL, MySQL, SQLite)

Example prompts

• "Write a Rust function using sqlx to select all users from the 'users' table."
• "Generate an SQL query that inserts a new record into the 'products' table with specified values."
• “Can you update the ‘orders’ table and set the status of order ID 123 to 'shipped'?”

Tips & gotchas

• Requires familiarity with Rust programming concepts.
• The agent needs access to a database connection string and appropriate credentials for successful query execution.