Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

data-write-query — Escrever SQL Otimizado · evolution-foundation | DecimalAI

databy evolution-foundation

data-write-query — Escrever SQL Otimizado

evolution-foundation/data-write-query

Source evolution-foundation/evo-nexus ↗License NOASSERTION

Escreve SQL otimizado para o stack Evolution (PostgreSQL primário) com boas práticas. Use quando precisar traduzir uma necessidade de dados em SQL, construir uma query com múltiplas CTEs, joins e agregações, otimizar uma query contra tabelas grandes, ou obter sintaxe específica para consultas no banco do Evo CRM, Evo AI, ou qualquer serviço do stack Evolution. Dialetos secundários disponíveis: Snowflake, BigQuery, MySQL, DuckDB.

SkillScore95Maintained

Automatic

Data Analyst pack

Last verified 8/19/2026

What it changes

Passed 21 of 22 test cases with the skill, and 19 of 22 without it.

Without skill86%

With skill95%

Checks it passed that the model alone missed

The query uses the ANY operator for array membership checks.
The query uses jsonb_array_elements to expand the JSON array.

2 fixed19 passed either way1 still failing0 broke

Pass-rate lift: +9 pp
Tokens: +145%
Agent turns: 0%
Response time: -10%

Model gemini-3.6-flashMeasured 8/19/2026v121 of 22 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/evolution-foundation-data-write-query/SKILL.md https://app.decimal.ai/s/evolution-foundation-data-write-query/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add evolution-foundation-data-write-query, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/evolution-foundation-data-write-query/ and pins it in .decimal/skills.lock

decimalai skills add evolution-foundation-data-write-query

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/evolution-foundation-data-write-query/SKILL.md https://app.decimal.ai/s/evolution-foundation-data-write-query/SKILL.md

Raw file: /s/evolution-foundation-data-write-query/SKILL.md ↗ · machine-readable summary at /s/evolution-foundation-data-write-query.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

One of 2 test cases the skill fixed. Same model, same prompt, with and without the skill.

1 of 2

Prompt

Write a query to fetch orders whose current status equals any entry within a list of allowed statuses: active, trial, or pending.

What was checked, without and with the skill
Checked	Without skill	With skill
The query uses the ANY operator for array membership checks.	Missed	Passed

case-19 · gemini-3.6-flash · 8/19/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md307 linessingle file

data-write-query — Escrever SQL Otimizado

Escreve uma query SQL a partir de uma descrição em linguagem natural, otimizada para o dialeto PostgreSQL (stack padrão Evolution) e seguindo boas práticas.

Uso

/data-write-query <descrição do que você precisa consultar>

Fluxo de Trabalho

1. Entender a Requisição

Analisar a descrição do usuário para identificar:

Colunas de saída: Quais campos devem estar no resultado?
Filtros: Quais condições limitam os dados (intervalos de tempo, segmentos, status)?
Agregações: Há operações GROUP BY, contagens, somas, médias?
Joins: É necessário combinar múltiplas tabelas?
Ordenação: Como os resultados devem ser classificados?
Limites: Há um requisito de top-N ou amostragem?

2. Determinar o Dialeto SQL

Dialeto primário do workspace:

PostgreSQL — padrão para todo o stack Evolution (Evo CRM, Evo AI, serviços internos, Aurora RDS, Supabase, Neon)

Dialetos secundários (se explicitamente solicitados):

Snowflake
BigQuery (Google Cloud)
Redshift (Amazon)
Databricks SQL
MySQL / Aurora MySQL
DuckDB
SQLite

Se o usuário não especificar, assumir PostgreSQL como padrão.

Track record

Benchmark

21 / 22

test cases passed, vs 19 / 22 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/3/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

evolution-foundation / evo-nexus

.claude/skills/data-write-query/SKILL.md

View on GitHub ↗

License NOASSERTIONImported 8/3/2026Version v1

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

data-write-query — Escrever SQL Otimizado

Uso

Fluxo de Trabalho

1. Entender a Requisição

2. Determinar o Dialeto SQL

Track record

Benchmark

Adoption

SkillSafety

Source

Related skills