Analyze and optimize SQL queries for better performance
Idioma del texto original: inglés
Menú
SkillsMP ha recopilado 21 skills de AltimateAI/altimate-code. Abre una skill para revisar su origen y sus detalles.
Mostrando 21 de 21 skills recopiladas.
Analyze and optimize SQL queries for better performance
Idioma del texto original: inglés
Cloudflare-style AI code review for dbt/SQL pull requests. Produces a signed APPROVE/COMMENT/REQUEST_CHANGES verdict where every blocking finding is backed by a deterministic engine call — column-lineage blast radius, query equivalence, PII classification,…
Idioma del texto original: inglés
REQUIRED before writing or modifying ANY dbt model. Invoke this skill FIRST whenever a task says "create", "build", "add", "modify", "update", "fix", or "refactor" a dbt model, staging file, mart, incremental, or snapshot. Skipping this skill is the leading…
Idioma del texto original: inglés
REQUIRED after building or modifying ANY dbt model that has columns declared in `schema.yml` / `_models.yml`. Run `altimate-dbt schema-verify --model <name>` to diff actual columns against the spec, and treat any `mismatch` verdict as "not done." The most…
Idioma del texto original: inglés
Generate dbt unit tests automatically for any model. Analyzes SQL logic (CASE/WHEN, JOINs, window functions, NULLs), creates type-correct mock inputs from manifest schema, and assembles complete YAML. Use when a user says "generate tests", "add unit tests",…
Idioma del texto original: inglés
Validate that two tables or query results are identical — or diagnose exactly how they differ. Discover schema, identify keys, profile cheaply, then diff. Use for migration validation, ETL regression, and query refactor verification.
Idioma del texto original: inglés
Add schema tests, unit tests, and data quality checks to dbt models. Use when validating data integrity, adding test definitions to schema.yml, writing unit tests, or practicing test-driven development in dbt. Powered by altimate-dbt.
Idioma del texto original: inglés
Analyze downstream impact of dbt model changes using column-level lineage and the dependency graph. Use when evaluating the blast radius of a change before shipping. Powered by altimate-dbt.
Idioma del texto original: inglés
Document dbt models and columns in schema.yml with business context — model descriptions, column definitions, and doc blocks. Use when adding or improving documentation for discoverability. Powered by altimate-dbt.
Idioma del texto original: inglés
Debug dbt errors — compilation failures, runtime database errors, test failures, wrong data, and performance issues. Use when something is broken, producing wrong results, or failing to build. Powered by altimate-dbt.
Idioma del texto original: inglés
Build modern, interactive data visualizations and dashboards using code-based component libraries (shadcn/ui, Recharts, Tremor, Nivo, D3, Victory, visx). Use this skill whenever the user asks to visualize data, build dashboards, create analytics views, chart…
Idioma del texto original: inglés
Translate SQL queries between database dialects (Snowflake, BigQuery, PostgreSQL, MySQL, etc.)
Idioma del texto original: inglés
Configure Altimate platform credentials for datamate and API access
Idioma del texto original: inglés
Analyze Snowflake query costs and identify optimization opportunities
Idioma del texto original: inglés
Classify schema columns for PII (SSN, email, phone, name, address, credit card) and check whether queries expose them. Use for GDPR/CCPA/HIPAA compliance audits.
Idioma del texto original: inglés
Analyze DDL migrations for data loss risks — type narrowing, missing defaults, dropped constraints, breaking column changes. Use before applying schema changes to production.
Idioma del texto original: inglés
Pre-merge SQL quality gate — lint 26 anti-patterns, grade readability/performance A-F, validate syntax, and scan for injection threats. Use before committing or reviewing SQL changes.
Idioma del texto original: inglés
Teach your AI teammate a pattern by showing it an example file from your codebase
Idioma del texto original: inglés
Train your AI teammate on team standards from a document or style guide
Idioma del texto original: inglés
Show what your AI teammate has learned — patterns, rules, glossary, and standards
Idioma del texto original: inglés
Compare column-level lineage between two versions of a SQL query to show added, removed, and changed data flow edges.
Idioma del texto original: inglés