SQL-Datenbanken

Sql Optimization Patterns

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.

Dokhacgiakhoa422

Database Postgresql

Enforce repository patterns, zero-downtime migrations, and indexing standards for PostgreSQL with TypeORM or Prisma. Use when defining entities, writing migrations, adding RLS policies, or optimizing query performance. (triggers: **/*.entity.ts, prisma/schema.prisma, **/migrations/*.sql, TypeOrmModule, PrismaService, PostgresModule)

HoangNguyen0403418

Database Mongodb

Apply expert schema design, indexing, and performance rules for MongoDB. Use when designing MongoDB schemas, creating indexes, or optimizing NoSQL query performance. (triggers: **/*.ts, **/*.js, **/*.json, mongo, mongoose, objectid, schema, model)

HoangNguyen0403418

Database Migrations

跨 PostgreSQL、MySQL 及常用 ORM（Prisma、Drizzle、Django、TypeORM、golang-migrate）的模式变更（schema changes）、数据迁移、回滚及零停机部署（zero-downtime deployments）的数据库迁移最佳实践。

Postgres Patterns

PostgreSQL 数据库模式，用于查询优化、架构设计、索引和安全性。基于 Supabase 最佳实践。

Postgres Patterns

PostgreSQL 数据库模式，涵盖查询优化、架构设计、索引和安全。基于 Supabase 最佳实践。

Clickhouse Io

ClickHouse 数据库模式、查询优化、分析以及高性能分析负载的数据工程最佳实践。

Table Schema (two layers: index vs Appendix)

Define evidence-first table schemas for a survey: what each table must answer, row unit, columns, and which evidence-pack fields are required to fill it. **Trigger**: table schema, schema-first tables, table design, 表格 schema, 先 schema 后填充. **Use when**: you want survey tables that are verifiable and fillable before LaTeX (typically Stage C4, after evidence packs exist). **Skip if**: `outline/table_schema.md` already exists and is refined (covers both index tables and Appendix tables; no placeholders; evidence mapping is explicit). **Network**: none. **Guardrail**: no invented facts; schema must be checkable and map each column to an evidence source.

WILLOSCAR410

Sql Queries

Generate SQL queries from natural language descriptions

paperclipai405

Postgres

PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.

planetscale400

Vitess

Vitess best practices, query optimization, and connection troubleshooting for PlanetScale Vitess databases. Load when working with Vitess databases, sharding, VSchema configuration, keyspace management, or MySQL scaling issues.

planetscale400

Mysql

Plan and review MySQL/InnoDB schema, indexing, query tuning, transactions, and operations. Use when creating or modifying MySQL tables, indexes, or queries; diagnosing slow/locking behavior; planning migrations; or troubleshooting replication and connection issues. Load when using a MySQL database.

planetscale400

Write Sql Queries

Guide for writing SELECT, INSERT, UPDATE, DELETE queries with workers-qb

G4brym390

Fantasia Sqlite Main

Designs SQLite usage in Fantasia Archive’s Electron main process: file locations under userData, native better-sqlite3 module constraints, and migrations. Use when editing electron-main database code, schema, or persistence paths.

vishiri387

H3 Pg

PostgreSQL bindings for H3 hexagonal grid system. Use when working with H3 cells in Postgres, including spatial indexing, geometry/geography integration, and raster analysis.

postgis364

Nw Query Optimization

SQL and NoSQL query optimization techniques, indexing strategies, execution plan analysis, JOIN algorithms, cardinality estimation, and database-specific query patterns

nWave-ai361

SEO On-Page: Schema / Structured Data

When the user wants to add or optimize structured data (Schema.org, JSON-LD). Also use when the user mentions "schema," "structured data," "JSON-LD," "rich results," "rich snippets," "Google rich snippets," "featured snippet schema," "add schema to page," "missing structured data," "schema validation error," "Schema Markup Validator," "Google Rich Results Test," "FAQ schema," "Article schema," "Organization schema," "JobPosting," "HowTo," "Event," "SoftwareApplication," "BreadcrumbList," "WebSite," "Recipe," "Product," or "Dataset." For SERP feature types and zero-click patterns, use serp-features. For AI search visibility strategy (not markup), use generative-engine-optimization. For HowTo step sections (placement, copy, vs FAQ), use howto-section-generator.

kostja94352

Data Write Query

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.

EvolutionAPI347

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.

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.

Generate Sql Update Book Descriptions

Generates SQL UPDATE statements to populate book descriptions in a database, strictly adhering to word count, content exclusion, and formatting constraints.

Sql Query Generation With Explicit Joins

Generates SQL queries adhering to the constraint of avoiding NATURAL JOIN syntax, using explicit JOIN conditions instead.

Postgresql Inventory Tracking Schema Design

Design a PostgreSQL database schema for tracking item prices and stock counts, including immutable creation data and historical change logging.

Postgres Sql Generator From English

Generates PostgreSQL queries from plain English instructions, adhering to specific syntax rules for date functions and intervals.

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.

Gradio Mysql Dashboard With Independent Chart

Develop a Gradio web application to search a MySQL database. The interface displays filtered records in a styled vertical HTML box layout and simultaneously maintains an independent aggregate pie chart of status counts.

Pandas Dataframe Complex Upsert Sync

使用 Pandas 和 SQLAlchemy 将 DataFrame 同步到 MySQL，处理 Merge 后缀，并应用复杂的字段比较逻辑（JSON解析、数值归一化、条件排除、字符串排序）以实现精确的 Upsert。

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.

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.