Upgrade this Spryker project's modules/features to a newer release. First checks whether the project's customisations are covered by tests at all and offers to close that gap,…
SPS Commerce integration. Manage data, records, and automate workflows. Use when the user wants to interact with SPS Commerce data.
Собирает статистику работы команды с инцидентами/багами SPT (проект SPT в Avito Jira) за период и публикует готовый отчёт на Confluence с графиками.
Use when making code or documentation changes in this repository. Provides consistent workflow and validation steps.
Spürbarkeit und Zwischenstaatlichkeit: prüft die einschlägigen Voraussetzungen, Dokumente, Risiken und Ausnahmen. Norm-/Quellenanker: Art.
Spürbarkeit und Zwischenstaatlichkeit: prüft die einschlägigen Voraussetzungen, Dokumente, Risiken und Ausnahmen. Norm-/Quellenanker: Art.
Use when users want to explore available SPVs, browse asset classes, discover what analytics or views exist for a transaction, or understand the data model (filterable columns,…
Enter explore mode - a thinking partner for exploring ideas, investigating problems, and clarifying requirements.
Downloads a competitor's live ad creatives — the actual MP4s and JPEGs — from the Meta Ad Library into a local swipe folder, through the Novoads API.
Spydra integration. Manage Organizations, Pipelines, Users, Goals, Filters. Use when the user wants to interact with Spydra data.
Requêtes SQL avancées pour l'analytique — window functions, CTEs récursives, pivots et optimisation de requêtes complexes.
Group and aggregate correctly, understanding what GROUP BY collapses, how HAVING differs from WHERE, and how nulls and empty groups behave.
Turn a bounded data question, schema summary, and sample rows into a reviewable SQL analysis plan.
Design, review, debug, or explain analytical SQL with correct grain, joins, filters, time logic, performance awareness, and validation.
Write, optimize, and debug SQL queries. Analyze query plans, suggest indexes, and translate between SQL dialects.
SQL development best practices for writing efficient, secure, and maintainable database queries
Review SQL for business logic correctness, semantic drift, aggregation risk, and silent definition changes.
Machine-readable gotcha rules for SQL and data engineering failure patterns. Loaded by data and SQL skills to enforce Never-do-X constraints grounded in real reporting failures.
Use when the user asks to write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with ORMs like Prisma, Drizzle, TypeORM, or…
Korrektes, performantes SQL ueber Dialekte; Schema/Migration. Trigger: SQL/DB-Query.
Store, compare, and bucket timestamps with explicit time zones so reports do not drift by a day and ranges do not miss rows.
Senior SQL specialist for query design, query optimization, and schema-aware performance work across relational databases.
Write, optimize, and debug T-SQL queries for Microsoft SQL Server. Covers CTEs, window functions, PIVOT, MERGE, APPLY operators, execution plan analysis, indexing strategies, and…
Master SQL fundamentals including SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP operations. Learn data types, WHERE clauses, ORDER BY, GROUP BY, and basic joins.
Review SQL or report logic for many-to-many joins, duplicate-grain risk, unsafe aggregation, and filter side effects.
Choose and write the right join so rows are neither lost nor multiplied, and know why a result set grew. Use when combining tables and the row count or the null columns look wrong.
Produce or continue a SQL bootcamp lesson for dinotable, or review Zoha's submitted SQL/ERD work. Use when Zoha asks for the next SQL lesson, help with a SQL exercise, or review…
Crea, spiega e revisiona query MySQL 8 per studenti, inclusi schemi da zero o estensioni di file .sql esistenti, CREATE TABLE, relazioni, SELECT, INSERT, UPDATE e DELETE.
Quick reference for common SQL patterns, CTEs, window functions, and indexing strategies. Triggers on: sql patterns, cte example, window functions, sql join, index strate — from…
A Data Engineering interviewer focused on database performance. Use this agent when you need to practice analyzing slow queries, designing optimal indexes, and understanding…
Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.
트리거: "쿼리 최적화", "slow query", "인덱스 추가", "쿼리가 느려요", "EXPLAIN 분석" 수행: 슬로우 쿼리 분석 → EXPLAIN/EXPLAIN ANALYZE 해석 → 인덱스 전략 제안 → 서브쿼리/JOIN 리팩토링 → 최적화 쿼리 출력 출력: 문제 진단 요약 + 개선된 SQL + 인덱스 DDL…
Quick reference for common SQL patterns, CTEs, window functions, and indexing strategies. Triggers on: sql patterns, cte example, window functions, sql join, index strate — from…
Quick reference for common SQL patterns, CTEs, window functions, and indexing strategies. Triggers on: sql patterns, cte example, window functions, sql join, index strate — from…
Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.
Write optimized SQL queries with joins, CTEs, window functions, and performance tuning. Based on Anthropic's Claude Cookbooks.
Generate SQL queries from natural-language requirements using SELECT, JOIN, GROUP BY, window functions, CTEs, and subqueries.
Use when when migrating spectral library data from file-based formats (JSON, CSV, binary) into a persistent store and need to support fast filtered queries on metadata and…
Build report-safe SQL from business requests with grain control, join discipline, filter logic, and validation notes.
Optimisation et administration SQL Server. Se déclenche avec "SQL Server", "SSMS", "execution plan", "index SQL Server", "Always On", "tempdb — from general/general-misc
Combine result sets with UNION, INTERSECT, and EXCEPT, and know when a join or an exists clause is the better tool.
Sql Transform Helper - Auto-activating skill for Data Pipelines. Triggers on: sql transform helper, sql transform helper Part of the Data Pipelines skill category.
Use when writing raw SQL — MariaDB/MySQL syntax, parameterization, raw migrations, seeders with `DB::statement` — even when the user just pastes a query and asks 'why is this…
Use any time the user asks to query an MSSQL database (SELECT / EXEC / metadata / "เช็ค proc/table") or wants to add, edit, remove, or test a database connection alias on this…
Add a new MSSQL connection alias to mcp-sqlbroker. Collects host/user/db/policy in chat. Password collected via the user's terminal by default (getpass hidden input); chat-paste…
Diff the source code (CREATE statement) of a proc/view/function across two aliases (or two databases on the same alias).
Install the mcp-sqlbroker local service (Windows / macOS / Linux). Triggers on "/sqlbroker-install", "/sqlbroker:install", "install sqlbroker", "set up sqlbroker service", "deploy…
List all configured SQL connection aliases on this host. Triggers on "/sqlbroker-list", "/sqlbroker:list", "list aliases", "show all sqlbroker connections", "what databases are…
Delete an SQL connection alias from mcp-sqlbroker config. Destructive — confirm with the user first. Triggers on "/sqlbroker-remove", "/sqlbroker:remove", "delete alias", "remove…
Rotate (replace) the password for an existing alias without re-entering host/user/db/policy. Triggers on "/sqlbroker-rotate", "/sqlbroker:rotate", "rotate password", "change…
Check mcp-sqlbroker service health, broker version, and configured aliases. Triggers on "/sqlbroker-status", "/sqlbroker:status", "is sqlbroker running", "check broker health",…
Test an SQL connection alias by running a quick identity query. Triggers on "/sqlbroker-test", "/sqlbroker:test", "test alias", "verify sqlbroker connection".
Scaffolds a new sqlc query in sql/queries/ and its repository seam, following go-performance-starter's data-access pattern (ADR-003).
Execute authoring T-SQL (DDL, DML, data ingestion, transactions, schema changes) against Microsoft Fabric Data Warehouse and SQL endpoints from agentic CLI environments.
Analyze Fabric Data Warehouse performance via CLI using sqlcmd and queryinsights views. Diagnose slow queries, SQL pool pressure, cache coldness, and recommend clustering keys.
Use when designing, reviewing, or changing SQLFluff rules and configuration policy for a SQL or dbt-style project.
SQLMesh patterns for data transformation with column-level lineage and virtual environments. Use when building data pipelines that need advanced features like automatic DAG…
Use when creating SQLModel database models, CRUD operations, queries with joins, or relationships. NOT when non-database operations, plain SQL, or unrelated data handling.
Batch-analyze a folder of SQL Server .sqlplan files and produce a summary dashboard of the top issues, most common check violations, and deduplicated missing indexes across all…
Analyze SQL Server deadlock XML (from system_health XE session, SSMS deadlock graph, or trace) to identify root cause and produce a prioritized remediation plan.