Skill for the DB area of Securacy. 25 symbols across 5 files.
Database Architect - Design schemas, indexes, migrations, query optimization, data integrity, recoverability, and reliable production…
Use when the user brings a spreadsheet (.xlsx, .csv, .tsv) into their BRICKS project and wants its data in the app — product lists, price…
Creates Spring Data JPA repositories following best practices.
Generate type-safe TypeScript, Java, or Python code from annotated SQL files using SQG (SQL Query Generator).
Universal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across all SQL…
Use when the user asks to write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with…
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server.
Analyzes SQL queries for missing indexes, N+1 patterns, suboptimal joins, and full table scans.
Generate parameter bindings for SQL files by analyzing database schema and extracting SQL placeholders.
Write SQL and design indexes that stay fast as data grows — composite index column ordering, keeping predicates sargable, avoiding…
Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis…
Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques.
Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.).
Making one SQL statement fast, from its execution plan rather than a guess: reading estimated against actual rows, finding the operation…
Guide for researching SQL syntax and behavior for database backends.
Database Architect skill. Use this when you need to modify the database schema, add tables, or seed data. This project uses RAW SQL…
Reviews SQLAlchemy code for session management, relationships, N+1 queries, and migration patterns.
Comprehensive SQLAlchemy skill for customer support tech enablement, covering ORM patterns, session management, query optimization, async…
Use when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or…
General guide for using the sqlite3 CLI to build composable knowledge databases.