Frappe Doctype

The frappe-doctype skill enables AI agents to interact directly with Frappe's database schema by creating, reading, updating, and deleting doctypes. It allows agents to dynamically manage custom data structures within the Frappe framework without manual code intervention.

When to use it

• Automatically generate new database tables for custom business logic during workflow execution.
• Modify existing field definitions or add validation rules on the fly based on user requirements.
• Clean up obsolete doctypes and their associated records to maintain a tidy database schema.
• Prototype rapid applications by defining complex data relationships between multiple entities instantly.

Key capabilities

• Create new doctypes with specified fields, types, and options.
• Read existing doctype definitions to inspect current schema structures.
• Update field properties such as labels, descriptions, and data types.
• Delete unused or deprecated doctypes from the system.

Example prompts

• "Create a new Doctype called 'ProjectTask' with fields for title, status, and due date."
• "Update the 'Customer' doctype to add a mandatory field for 'Tax ID'."
• "List all available fields currently defined in the 'Employee' doctype."

Tips & gotchas

Ensure you have write permissions on the target Frappe instance before attempting to create or modify doctypes, as schema changes are permanent. Always validate that new field types align with your application's data integrity requirements to prevent runtime errors.