DZQL Architect Skill

What problem does it solve?

Building database-driven applications often involves extensive boilerplate: defining schemas, creating APIs, implementing permissions, and setting up real-time updates. This Skill eliminates that manual effort by transforming your high-level domain descriptions into a complete, production-ready DZQL implementation, allowing you to focus on your application's unique logic.

Core Features & Use Cases

• Domain-to-SQL Transformation: Converts natural language domain descriptions into comprehensive PostgreSQL schemas, including tables, indexes, constraints, and DZQL entity registrations.
• Automated API Generation: Instantly provides a full CRUD (Create, Read, Update, Delete) API with real-time WebSocket updates, fine-grained row-level security, and foreign key expansion, all defined directly in SQL.
• Full Project Scaffolding: Generates a complete project structure, including Docker Compose for PostgreSQL, server entry points, and comprehensive test suites, ready for immediate deployment.
• Use Case: Describe a "social habit tracker" with users, streaks, logs, and sharing features. This Skill will output all the necessary SQL, API definitions, and tests to bring that application to life, saving weeks of development time.

Quick Start

Generate a complete DZQL implementation for a 'project management system' with users, projects, tasks, and comments, including permissions for project owners and task assignees.