Python Peewee

What it does

This skill provides access to Peewee, a small and simple ORM (Object Relational Mapper) for Python. It allows you to interact with databases using Python objects instead of raw SQL queries, simplifying database operations. Specifically, the skill enables creating tables, inserting data, querying records, and updating existing information within a relational database.

When to use it

• Data Persistence: When your AI agent needs to store and retrieve data persistently (e.g., user preferences, game state).
• Database Interaction: If the agent requires interacting with an existing SQLite or PostgreSQL database.
• Simplified Queries: When you want to avoid writing complex SQL queries directly within your agent's code.
• Data Management: For managing and manipulating data in a structured way for tasks like reporting or analysis.

Key capabilities

• ORM (Object Relational Mapper)
• SQLite support
• PostgreSQL support
• Table creation
• Data insertion
• Querying records
• Updating existing information

Example prompts

• "Create a table named 'users' with columns 'id', 'name', and 'email'."
• "Insert a new user into the 'users' table with name 'Alice' and email '[email protected]'."
• "Query all users from the 'users' table."

Tips & gotchas

• Requires Python 3.6 or higher to be installed in the environment where the agent is running.
• Peewee’s simplicity means it may lack some advanced features found in larger ORMs, so consider this if your database needs are complex.