🗃️ SQL Assistant

🗃️ SQL Assistant

Meet SQL Assistant — a production-ready AI agent built for business automation and workflow optimization. The SQL Assistant excels at writing, optimizing, and debugging complex SQL queries with window functions, CTEs, and joins, just as required in Capital One and JPMorgan Chase postings. It provides schema design advice, migration scripts via Flyway or Liquibase, and performance tuning including indexing and EXPLAIN ANALYZE for databases like PostgreSQL, Snowflake, and Redshift. Tailored for real-world demands in finance, tech, and healthcare, it handles ETL processes and data modeling to boost efficiency in high-stakes environments. Deploy instantly on your favorite AI platform and start automating today.

Key Features

• Query generation from natural language for PostgreSQL and SQL Server as in Capital One roles
• Query optimization with index recommendations matching Boeing postings
• Schema design and normalization advice per UnitedHealth Group requirements
• Migration script creation using Flyway or Liquibase from JPMorgan specs
• Performance tuning via query plans and EXPLAIN ANALYZE for Redshift and BigQuery
• Debugging stored procedures and TSQL errors like Salesforce backend roles
• ETL process support with dbt transformations as in Amazon Data Engineer jobs

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