optimize-clickhouse-queries
Optimize slow queries, analyze SQL performance, and collect evidence for expensive workloads.
profiling-tables
Deep-dive data profiling for a specific table. Use when the user asks to profile a table, wants statistics about a dataset, asks about data quality, or needs to understand a table's structure and content. Requires a table name.
database-testing
Database schema validation, data integrity testing, migration testing, transaction isolation, and query performance. Use when testing data persistence, ensuring referential integrity, or validating database migrations.
nest-7175-c
将旧版NEST代码迁移至7.17.5版本，处理查询结构变更、聚合API更新及枚举修正，并提供中文解释。
nest-7-17-5-csharp-migration-refactor
将旧版NEST代码迁移至NEST 7.17.5版本，处理Facets到Aggregations、Filtered到Bool查询、字段路径、范围查询方法及枚举值的变更。
upgrade-nest-csharp-1x-to-7x
将基于NEST 1.x版本的C#代码迁移升级到NEST 7.17.5版本，涵盖索引管理、映射、查询构建、源字段过滤、聚合及MultiSearch的API语法变更。
qe-database-testing
Database schema validation, data integrity testing, migration testing, transaction isolation, and query performance. Use when testing data persistence, ensuring referential integrity, or validating database migrations.
firebase-anonymous-google-migration-utility
Refactors Firebase anonymous-to-Google account migration logic into static utility classes, handling data merging, collision detection, and cleanup via callbacks and context passing.
generate-user-activity-sql-table-and-mock-data
Generates the SQL CREATE TABLE script for a specific user_activity schema and populates it with mock data simulating continuous, returning, and churned users over a monthly period.
oracle-sql
针对Oracle SQL查询请求，仅输出纯文本SQL语句，不使用Markdown代码块，不提供任何解释，以避免终端显示乱码。
create-empty-sqlite-database-file-non-interactively
Provides the specific command to create an empty SQLite database file on Debian without entering the interactive shell, suitable for use with ORMs like Hibernate.
create-empty-sqlite-database-file-non-interactively
Provides the specific command to create an empty SQLite database file on Linux/Debian without entering the interactive shell, intended for use with ORMs like Hibernate.
clean-sql-output-for-excel
Formats raw SQL query results for Excel by removing metadata, rounding numbers, and ensuring a professional layout.
c-winforms-sql-search-to-datagridview
Generates C# code to perform a parameterized SQL search and display results in a DataGridView, including input validation and specific connection handling.
define-sqlalchemy-weekly-schedule-array
Defines a SQLAlchemy column for a weekly schedule using a 7x3 array structure with specific time and integer types.
plsql-sea-cruises-database-management
Создание базы данных морских круизов и портов на PL/SQL с отношением один-ко-многим, включая пакет для управления данными (заполнение, очистка, удаление) и триггер для защиты от удаления при малом количестве записей.
didactic-sql-explanation-with-analogies
Explains technical concepts, specifically SQL and database topics, using real-life analogies and a concise, beginner-friendly tone with strict code formatting rules.
rust-sqlx-migration-add-column-and-backfill-with-nanoid
Guides the user on adding a new TEXT column to a PostgreSQL table using SQLx migrations and backfilling existing rows with nanoid values, specifically targeting rows where the column is NULL.
pandas-dataframe-complex-upsert-sync
使用 Pandas 和 SQLAlchemy 将 DataFrame 同步到 MySQL，处理 Merge 后缀，并应用复杂的字段比较逻辑（JSON解析、数值归一化、条件排除、字符串排序）以实现精确的 Upsert。
postgresgpt-sql-generator
Acts as PostgresGPT to generate PostgreSQL queries from natural language descriptions, adhering to specific syntax preferences for date functions.