sql-formatter
Formats SQL queries for better readability and consistency. Supports PostgreSQL, MySQL, and SQLite syntax. Not for: database schema design, query optimization, or data migration.
Formats SQL queries for better readability and consistency. Supports PostgreSQL, MySQL, and SQLite syntax. Not for: database schema design, query optimization, or data migration.
Guide for Convex performance optimization including denormalization, index design, avoiding N+1 queries, OCC (Optimistic Concurrency Control), and handling hot spots. Use when optimizing query performance, designing data models, handling high-contention writes, or troubleshooting OCC errors. Activates for performance issues, index optimization, denormalization patterns, or concurrency control tasks.
设计和优化数据库模式,支持PostgreSQL、MySQL、SQLite和MongoDB。包括ER建模、规范化、索引优化和迁移脚本生成。
Write correct Neumann database queries. Use when writing NODE, EDGE, EMBED, SIMILAR, ENTITY, VAULT, CACHE, BLOB, CHECKPOINT, CHAIN, or CLUSTER commands, or any Neumann SQL query.
Token-Oriented Object Notation (TOON) format expert for 30-60% token savings on structured data. Auto-applies to arrays with 5+ items, tables, logs, API responses, database results. Supports tabular, inline, and expanded formats with comma/tab/pipe delimiters. Triggers on large JSON, data optimization, token reduction, structured data, arrays, tables, logs, metrics, TOON.
Use when building database queries with frappe.qb in Frappe v14-v16. Covers the PyPika-based query builder: SELECT, INSERT, UPDATE, DELETE, joins, aggregation, subqueries, cross-DB compatibility (MariaDB/PostgreSQL), and migration from raw SQL. Prevents SQL injection and DB-specific bugs. Keywords: frappe.qb, query builder, DocType, Field, pypika, join,, frappe.qb example, how to write query, join tables, SQL replacement, parameterized query. aggregate, ImportMapper, cross-database, parameterized query.
When the user needs help writing SQL queries, analyzing data, building reports, or says 'write a query,' 'SQL help,' 'pull this data,' 'how many users,' 'funnel analysis,' 'cohort analysis,' 'retention query,' or needs to extract insights from a database.
SS14 Database System Guide (PostgreSQL and SQLite)
SS14 Database System Guide (PostgreSQL and SQLite)
SS14 Database System Guide (PostgreSQL and SQLite)
Guide to Creating and Managing Database Migrations in SS14 (PostgreSQL and SQLite)
SS14 Database System Guide (PostgreSQL and SQLite)
SS14 Database System Guide (PostgreSQL and SQLite)
This skill should be used when working with SQL databases, "SELECT", "INSERT", "UPDATE", "DELETE", "CREATE TABLE", "JOIN", "INDEX", "EXPLAIN", transactions, or database migrations. Provides comprehensive SQL patterns across PostgreSQL, MySQL, and SQLite.
Local Drizzle ORM documentation reference (latest). Use when asked about Drizzle ORM queries, schema definitions, migrations, column types, PostgreSQL/MySQL/SQLite dialects, Drizzle Kit, or database operations.
Local Turso documentation reference (latest). Use for libSQL, SQLite at the edge, embedded replicas, Turso CLI, and database sync.
Local Prisma documentation reference. Use when asked about Prisma ORM, Prisma Client, Prisma Schema, migrations, database queries, Prisma Accelerate, or Prisma Postgres.
Design and implement production database systems. Covers schema design, migrations, query optimization, ORMs (Prisma, Drizzle, TypeORM), PostgreSQL/SQLite/MongoDB patterns, indexing strategies, connection pooling, and multi-tenant architectures. Use when designing schemas, writing queries, or setting up data access layers.
Use when defining data structures using Ecto schemas including fields, associations, embedded schemas, and schema metadata. Use for modeling domain data in Elixir applications.
Use when lINQ (Language Integrated Query) with query and method syntax, deferred execution, expression trees, and performance optimization.