Skills tagged "sql" (180)

🛡️ Backend Queries

This skill helps you write secure, efficient backend queries using parameterized queries, ORM builders, and proper optimization strategies.

backenddatabasesqlsecurity

📋 Backfill

This skill helps you backfill historical Stripe data into PostgreSQL using stripe-sync-engine for efficient, scalable data recovery.

databasebackenddatasql

📋 Bi Analyst

This skill helps you master BI fundamentals including metric definitions, KPI calculations, dimensional modeling, and dashboard optimization for rapid data

dataanalyticssqldatabase

🧪 Building Dbt Semantic Layer

This skill guides creating and modifying dbt semantic layer components, including models, entities, dimensions, and metrics, with validation and spec guidance.

dataanalyticspythonsql

🧪 Cli Expert

This skill helps you build robust npm CLI tools by applying Unix-inspired patterns, automatic project root detection, cross-platform arg parsing, and

cliscriptingproductivitydebugging

📋 Clickhouse Materialized Views

This skill helps you design and manage ClickHouse materialized views for real-time aggregation and data transformation, optimizing queries and avoiding common

databasesqldataanalytics

🐛 Clickhouse Query Optimization

This skill helps you optimize ClickHouse queries with 20+ rules to achieve faster runs and lower memory usage.

databasesqlperformancedebugging

🐛 Clickhouse Schema Design

This skill helps you design ClickHouse schemas with optimized ORDER BY, partitioning, and data types to achieve sub-second queries and strong compression.

databasesqldataanalytics

⚙️ Cron

This skill helps you manage Codex automations by editing the local SQLite store and filesystem configs, enabling fast creation, updates, and runs.

automationsqlscriptingpython

📋 D6e Docker Stf Development

This skill helps you build Docker-based State Transition Functions for D6E to process data, access internal SQL APIs, and output JSON.

backendapisqldata

🧪 Dart Drift

This skill guides Dart Drift usage for local SQLite and PostgreSQL with type-safe queries, migrations, and reactive streams.

databasesqlmigrationtesting

⚙️ Data Analysis

This skill analyzes datasets to extract insights, perform statistical analysis, and generate reports for data-driven decision making.

dataanalyticsdatabasesql

⚙️ Data Analyst

This skill helps you perform exploratory data analysis and advanced SQL analytics to derive business insights from complex datasets.

sqldataanalyticsdatabase

📋 Data Engineer

This skill helps you design data warehouses using star schemas and slowly changing dimensions to improve query performance and accuracy.

databasesqldataanalytics

📋 Data Engineering

This skill helps you design and optimize data pipelines and warehousing with Spark, Airflow, and Delta Lake for scalable analytics.

dataanalyticscloudsql

📋 Database

This skill helps you add and connect a database (Postgres, Redis, MySQL, MongoDB) to your project by deploying templates and wiring variables.

databaseinfradevopscloud

🛡️ Database

This skill helps you design multi-tenant database schemas, choose a suitable platform, and implement secure, scalable data patterns for SaaS.

databasesqldatasecurity

📋 Database Conventions

This skill helps you design multi-tenant databases with snake_case fields, RLS, and migrations for Drizzle and SQLModel across schemas.

databasesqlmigrationbackend

📋 Database Designer

This skill designs scalable database schemas and multi-tenant migrations for PHP/CakePHP projects, ensuring normalized structures and maintainable migrations.

databasesqlmigrationbackend

🐛 Database Query Optimizer

This skill analyzes and optimizes database queries across PostgreSQL, MySQL, and MongoDB by interpreting EXPLAIN plans and suggesting indexes.

databasesqlperformancedebugging

🛡️ Database Schema

This skill ensures database code uses schema-verified columns and generated types to prevent runtime errors.

databasesqlsecuritybackend

📋 Database Schema Designer

This skill designs optimized database schemas, ER diagrams, and DDLs, delivering normalization and performance plans to accelerate data-driven applications.

databasesqldatadesign

📋 Database Schema Manager

This skill helps you design, validate, and migrate LibSQL/Turso schemas with Zod for type-safe, scalable database operations.

backenddatabasesqldata

🛡️ Database Schema Validator

This skill validates SQL schemas against internal safety and naming policies, ensuring snake_case tables and mandatory id primary keys.

databasesqlsecuritylinting

📋 Databases Sql

This skill helps you write efficient SQL across platforms, optimize queries, and design analytics-ready databases for data warehousing.

sqldataanalyticsdatabase

🧪 Dbmate

This skill helps you manage database migrations with dbmate by creating, writing, and applying engine-specific migrations safely.

databasemigrationsqldevops

🧪 Dbt Migration Oracle

This skill converts Oracle DDL to dbt models for Snowflake, preserving logic, adding tests and docs, and outlining architecture decisions.

datasqlpythoncloud

🧪 Dbt Migration Postgres

This skill converts PostgreSQL/Greenplum/Netezza DDL into dbt models compatible with Snowflake, preserving logic and generating tests and documentation.

sqldatamigrationtesting

🧪 Dbt Projects

This skill documents and tests dbt projects with YAML conventions, sources, macros, and CI patterns to guide when designing, validating, and auditing models.

sqldatadocsanalytics

🧪 Dbt Testing

This skill helps you implement comprehensive dbt testing with constraints, generic and singular tests across bronze to gold layers for data quality.

databasedatatestingsql

📋 Deepdive

This skill translates natural language queries into SQL, visualizes schemas, and generates charts to accelerate database insights.

databasesqldataanalytics

🔍 Depot Services Review

This skill reviews Rust depot services focusing on Axum, SQLx, WebSocket, and Docker patterns to improve reliability and integration.

backenddebuggingcode-reviewdatabase

📋 Design Postgres Tables

This skill helps you design robust PostgreSQL tables by applying best practices for keys, normalization, indexing, constraints, and data types.

databasesqldataperformance

🧪 Differential Fuzzer

This skill helps you run and analyze the differential fuzzer for Turso, comparing results with SQLite to uncover correctness bugs.

databasesqltestingdebugging

📋 Distributed Locking Rfc 44

This skill helps you implement RFC-44 compliant distributed locking using PostgreSQL or Redis to coordinate jobs across instances.

backenddatabasemigrationsql

🐛 Doc

This skill provides PostGIS-focused SQL guidance and best practices for geospatial data handling in PostgreSQL.

databasesqlperformancedebugging

🔍 Drizzle Migration

This skill guides you through generating, reviewing, and applying Drizzle Kit migrations to update the asset-forge database schema.

migrationdatabasesqlbackend

🐛 Drizzle Orm

This skill helps you design and use Drizzle ORM efficiently on edge and serverless platforms, ensuring type safety, SQL-first workflows, and reliable

databasesqlcloudbackend

⚙️ Drizzle Orm V0

This skill helps you build type-safe, scalable database layers in TypeScript using Drizzle ORM with migrations, relations, and safe queries.

backenddatabasesql

⚙️ Dsql Skill

This skill helps you manage Aurora DSQL schemas, run transactions, and migrate safely using MCP tools for scalable, multi-tenant databases.

databasesqlcloudmigration

🧪 Durable Objects

This skill helps you design, review, and test Cloudflare Durable Objects for stateful coordination, RPC, and durable storage at the edge.

clouddatabasesqldata

⚙️ Evolutionary Metric Ranking

This skill helps you optimize multi-metric configurations using percentile cutoffs and evolutionary search to discover robust, intersection-based winners.

aiautomationdevopsdata

📋 Ezorm

This skill helps you select the right Ezorm task: write YAML or generate Go from YAML for MongoDB or MySQL.

databasebackendsqlwriting

⚙️ Ezorm Gen Yaml Mysql

This skill generates Go code from ezorm YAML schemas for mysql and mysqlr using the ezorm CLI, guiding you with exact commands.

backenddatabasesqlcli

📋 Find Hypertable Candidates

This skill analyzes a PostgreSQL schema to identify hypertable candidates and guides migration with TimescaleDB best practices.

databasesqldataanalytics

🧪 Fixture Generator

This skill generates CakePHP test fixtures directly from migration files, integrates Configure::read usage, and supports multi-database environments.

migrationtestingautomationcli

🎨 Flutter Drift

This skill guides you to implement a resilient local SQLite store in Flutter with drift, enabling type-safe queries, reactive streams, and smooth migrations.

databasesqldatamigration

📝 Foundations

This skill helps you master data analytics fundamentals, spreadsheet techniques, and data collection methods to improve data-driven decision making.

dataanalyticsdatabasesql

📋 Frappe Performance Optimizer

This skill generates optimized queries, caching, and indexes to boost Frappe performance and eliminate slow queries.

databaseperformancebackendpython

⚙️ Frappe Report Generator

This skill helps you create and customize Frappe reports including query, script, and nocode builders for powerful data analysis.

backenddatabasesqlpython

📋 Grepai Storage Postgres

This skill helps teams configure PostgreSQL with pgvector for GrepAI, enabling scalable, concurrent, and persistent semantic code search across large codebases.

databasesqldevopsperformance

⚙️ Hubspot Revops Skill

This skill helps you build revenue analytics on HubSpot by connecting API data, SQL warehouse queries, and ML scoring to drive actionable insights.

pythonapisqlanalytics

⚙️ Hugging Face Datasets

This skill helps you create, configure, and query Hugging Face datasets with SQL, templates, and streamlined uploads.

sqldataapibackend

📝 Index Knowledge

This skill generates a hierarchical AGENTS.md knowledge base for a codebase, creating root and subdirectory documentation with complexity scoring.

databasesqlrustdocs

⚙️ Init

This skill initializes warehouse schema discovery, generating a ready-to-edit .astro/warehouse.md with table metadata for instant lookups and drift-aware

datasqlautomationanalytics

🛡️ Injection Vulnerabilities

This skill analyzes AI-generated code to identify and explain injection vulnerabilities such as SQL injection, command injection, and XSS, with secure

securitycode-reviewaidatabase

📋 Markdown Docs

This skill helps you understand Materialize queries, sources, sinks, and views by summarizing key concepts from the official docs.

sqldatabasedataanalytics

⚙️ Memory System

This skill enables cross-session memory via a local Markdown/indexed SQLite, providing fast memory search, add, and prune workflows.

datadatabasesqlpython

📋 Migrate Postgres Tables To Hypertables

This skill guides migrating PostgreSQL tables to TimescaleDB hypertables with configuration, planning, and validation to maximize performance.

databasemigrationsqlperformance

📋 Migrations

This skill helps you set up and run Stripe Sync Engine migrations in PostgreSQL, ensuring stripe schema and migrations table are created.

databasemigrationbackendsql