SQL 資料庫

This skill should be used for OWASP, security review, authentication, XSS, SQL injection prevention, CSRF, input validation, secure coding, vulnerability scanning

Complete guide to ActiveRecord query optimization, associations, scopes, and PostgreSQL-specific patterns. Use this skill when writing database queries, designing model associations, creating migrations, optimizing query performance, or debugging N+1 queries and grouping errors. Trigger keywords: database, models, associations, validations, queries, ActiveRecord, scopes, migrations, N+1, PostgreSQL, indexes, eager loading

Expert guidance for writing optimized SQL queries for Apache Superset datasets, virtual datasets, and SQL Lab. This skill helps you create performant queries, design efficient datasets, and leverage PostgreSQL features - with specific patterns for Finance SSC, BIR compliance, and Odoo integration.

Universal vulnerability detection patterns applicable across all programming languages. Includes hardcoded secrets, SQL/command injection, path traversal, and configuration file patterns.

Build secure WordPress plugins with core patterns for hooks, database interactions, Settings API, custom post types, REST API, and AJAX. Covers three architecture patterns (Simple, OOP, PSR-4) and the Security Trinity.Use when creating plugins, implementing nonces/sanitization/escaping, working with $wpdb prepared statements, or troubleshooting SQL injection, XSS, CSRF vulnerabilities, or plugin activation errors.

Understand and utilize the project's technology stack including NestJS, Next.js, Prisma, PostgreSQL, and TypeScript. Use this skill when making technology decisions, when choosing libraries or packages, when understanding framework-specific patterns, or when configuring development tools. This includes NestJS with feature-based modular architecture, Next.js 15 with App Router, Prisma ORM for database access, PostgreSQL, TypeScript with strict mode, pnpm for package management, Turborepo for monorepo orchestration, and shared workspace packages. Apply when setting up new features, choosing dependencies, or understanding the overall system architecture.

Design and implement database schemas using SQLModel with sync and async patterns. Use this skill when creating database models, setting up Neon PostgreSQL connections, defining relationships (one-to-many, many-to-many), implementing FastAPI dependency injection, or migrating schemas. Covers both sync Session and async AsyncSession patterns.

Build with D1 serverless SQLite database on Cloudflare's edge. Use when: creating databases, writing SQL migrations, querying D1 from Workers, handling relational data, or troubleshooting D1_ERROR, statement too long, migration failures, or query performance issues.

Database specialist covering PostgreSQL, MongoDB, Redis, and advanced data patterns for modern applications

Detect common security vulnerabilities in code. Covers OWASP patterns, SQL injection, bare excepts, shell injection. Framework-agnostic.

Complete guide to ActiveRecord query optimization, associations, scopes, and PostgreSQL-specific patterns. Use this skill when writing database queries, designing model associations, creating migrations, optimizing query performance, or debugging N+1 queries and grouping errors.

Production-ready Auth.js v5 setup for Next.js and Cloudflare Workers.Use when: setting up authentication, implementing OAuth/credentials/magic links,configuring D1 or PostgreSQL adapters, debugging session issues, migrating fromv4 to v5, fixing edge compatibility, troubleshooting JWT/database sessions,resolving AUTH_SECRET errors, fixing CallbackRouteError, or implementing RBAC.Covers: Next.js App Router & Pages Router, Cloudflare Workers + D1, OAuth providers(GitHub, Google, etc.), credentials auth, magic links, JWT vs database sessions,middleware patterns, role-based access control, token refresh, edge runtimecompatibility, and common error prevention.Keywords: Auth.js, NextAuth.js, authentication, OAuth, credentials, magic links,D1 adapter, Cloudflare Workers, Next.js middleware, JWT session, database session,refresh tokens, RBAC, edge compatibility, AUTH_SECRET, CallbackRouteError,CredentialsSignin, JWEDecryptionFailed, session not updating, route protection

将已有 SQL 接入到数据栈的某一层（ODS/DIM/DWD/ADS）。当用户需要添加新表、接入数据源、配置数据层时使用。支持配置 sources、table_dependencies、创建 migration 文件。

Understand the toy relational database architecture, crate organization, data flow, and implementation patterns. Use when exploring the database codebase, understanding query execution, debugging storage/indexing, or planning new features. Keywords: sql-database, database, crate, storage, executor, planner, parser, catalog, WAL, buffer pool, index, architecture

Infrastructure as Code with Terraform for cloud Kubernetes clusters. Covers OKE (Oracle), AKS (Azure), GKE (Google) provisioning, multi-cloud patterns, and state management.

Path-grounded multi-agent orchestration using the Liku directory hierarchy (skills.xml inheritance, todo.md + LikuErrors.md audit trail, SQLite memory). Use when you need to initialize Liku, generate an agent bundle for a specific Liku/* residence path, or expose Liku as an MCP server for Gemini-CLI, Claude Code, Copilot-CLI, or ChatGPT Codex.

Generate realistic database seed data and test fixtures for development, testing, and demonstrations. Creates realistic users, products, orders, and custom schemas using Faker libraries while maintaining relational integrity and data consistency. Use when populating databases, creating test fixtures, seeding development environments, or generating demo data.

Prisma ORM and PostgreSQL database management for EFT-Tracker. Handles schema design, migrations, client generation, and Neon database branches. Activates when user mentions: database, schema, migration, Prisma, model, relation, PostgreSQL, Neon, db push, db pull.

Master Entity Framework Core advanced patterns including change tracking optimization, lazy/eager/explicit loading strategies, query splitting, compiled queries, batch operations, optimistic concurrency, performance optimization, and PostgreSQL-specific features for .NET applications.

Modify database repository adapters using sqlc-generated SQLite queries.