This skill should be used when the user asks to "test for SQL injection vulnerabilities", "perform SQLi attacks", "bypass authentication using SQL injection", "extract database information through injection", "detect SQL injection flaws", or "exploit database query vulnerabilities". It provides comprehensive techniques for identifying, exploiting, and understanding SQL injection attack vectors across different database systems.
Capable of converting raw SQL queries into type-safe Kysely TypeScript code. Knows how to handle various SQL dialects and complex query structures.
Use when you need to work with stored procedure generation. This skill provides stored procedure code generation with comprehensive guidance and automation. Trigger with phrases like "generate stored procedures", "create database functions", or "write SQL procedures".
Detect and analyze SQL injection vulnerabilities in application code and database queries. Use when you need to scan code for SQL injection risks, review query construction, validate input sanitization, or implement secure query patterns. Trigger with phrases like "detect SQL injection", "scan for SQLi vulnerabilities", "review database queries", or "check SQL security".
Expert guidance for SQLite database with better-sqlite3 Node.js driver including database setup, queries, transactions, migrations, performance optimization, and integration with TypeScript. Use this when working with embedded databases, better-sqlite3 driver, or SQLite operations.
Use when you need to work with ORM code generation. This skill provides ORM model and code generation with comprehensive guidance and automation. Trigger with phrases like "generate ORM models", "create entity classes", or "scaffold database models".
Use when you need to work with NoSQL data modeling. This skill provides NoSQL database design with comprehensive guidance and automation. Trigger with phrases like "model NoSQL data", "design document structure", or "optimize NoSQL schema".
MySQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns.
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
SQL Server (MSSQL) 数据库工具集，用于连接数据库实例、列出所有表、查看表结构、执行 SQL 查询等操作。当需要操作 SQL Server 数据库、查询数据、分析表结构时使用此技能。支持通过命令行参数指定 server、port、user、password、database 等连接信息，可代替 mssql mcp 服务使用。支持 Windows、macOS 和 Linux 平台。
MySQL 数据库工具集，用于连接数据库实例、列出所有表、查看表结构、执行 SQL 查询等操作。当需要操作 MySQL 数据库、查询数据、分析表结构时使用此技能。支持通过命令行参数指定 host、port、user、password、database 等连接信息，可代替 mysql mcp 服务使用。支持 Windows、macOS 和 Linux 平台。
SQLite 数据库工具集，用于操作 SQLite 数据库文件。支持 .db、.sqlite、.sqlite3、.vscdb 等常见扩展名。无需额外安装依赖，使用 Python 内置 sqlite3 模块。支持 Windows、macOS 和 Linux 平台。
Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate).
Design relational database schemas from requirements and generate migrations, TypeScript/Python types, seed data, RLS policies, and indexes. Handles multi-tenancy, soft deletes, audit trails, versioning, and polymorphic associations.
Advises on database selection, schema design, indexing, query optimization, and migration. Covers SQL, NoSQL, Graph, Columnar, Key-Value, Time Series, NewSQL, Vector, Serverless, Data Warehouse, Embedded, Multi-Model, Streaming, and Decentralized databases. 100+ database technologies including PostgreSQL, MySQL, MongoDB, Redis, Kafka, Neo4j, Cassandra, ClickHouse, DynamoDB, CockroachDB, Pinecone, Snowflake, and ORMs (Prisma, Drizzle, SQLAlchemy, GORM, Diesel, EF Core, Hibernate). Use when selecting databases, designing schemas, optimizing queries, or planning migrations.
Write optimized SQL for your dialect with best practices
