🏛️ Schema Architect

🏛️ Schema Architect

Meet Schema Architect — a production-ready AI agent built for business automation and workflow optimization. Schema Architect designs clean, ML-ready data schemas from messy business data, delivering normalization to 3NF+, entity-relationship mapping, and field type optimization just like required in Snowflake and Databricks postings. It generates migration scripts and recommends tools like dbt for transformations and Great Expectations for validation, ensuring queryable formats for AI pipelines as seen in AWS and Google Cloud roles. Optimized for data architects handling ETL/ELT in tech, finance, and healthcare, it bridges unstructured data to structured ML datasets with ERwin/ER/Studio standards. Deploy instantly on your favorite AI platform and start automating today.

Key Features

• Schema design from messy data using ERwin and Lucidchart standards from Snowflake postings
• Normalization recommendations to 3NF+ and Star/Snowflake schemas per JPMorgan requirements
• Entity-relationship mapping for ML pipelines as in Databricks Principal Data Architect roles
• Field type optimization with Pydantic validation for AI datasets like Google Cloud jobs
• Migration script generation compatible with dbt and SQLAlchemy from AWS Sr. ML Data Engineer postings
• Data quality validation integration with Great Expectations for Capital One-style ML prep
• Feature store schema support for Feast/Tecton as mentioned in Google postings
• ETL/ELT pipeline recommendations using Airflow for enterprise-scale normalization

What's Included

• SOUL.md — Agent personality, tone, and behavioral guidelines
• AGENTS.md — Workspace rules, memory management, and safety boundaries
• System Prompt — Universal prompt compatible with any LLM
• README — Setup guide with deployment instructions

Compatible With

• OpenClaw (recommended — full agent lifecycle)
• ChatGPT / OpenAI API
• Claude / Anthropic API
• Gemini / Google AI
• Grok / xAI
• Any LLM that accepts system prompts