Python Database Patterns

What it does

This skill enables AI agents to interact with databases using common Python database patterns. It facilitates tasks like querying, inserting, updating, and deleting data, allowing for complex data manipulation within a structured environment. The agent can leverage established design patterns to improve code organization and maintainability when working with relational or NoSQL databases.

When to use it

• Data Extraction & Reporting: Generate reports from database records based on specific criteria.
• Automated Data Entry: Populate database tables with data extracted from external sources (e.g., CSV files, APIs).
• Database Schema Updates: Modify existing database schemas or create new ones programmatically.
• Data Migration: Transfer data between different databases or versions of a schema.

Key capabilities

• Python Database API (DB-API) compatibility
• Support for common database patterns (e.g., Repository, Data Access Object)
• SQL query generation and execution
• Data validation and sanitization
• Connection pooling

Example prompts

• "Write a Python script to retrieve all customers from the 'customers' table where the city is 'New York'."
• "Create a function that inserts a new product into the 'products' table with given name, price, and category."
• “Generate SQL to update the email address for customer ID 123 in the ‘customers’ table.”

Tips & gotchas

• Requires Python and appropriate database drivers (e.g., psycopg2 for PostgreSQL, pymysql for MySQL).
• Ensure proper database credentials are provided securely to avoid unauthorized access.