Loading...
Loading...
Found 1,411 Skills
Guides FastAPI backend design using Domain-Driven Design (DDD) and Onion Architecture in Python. Use when structuring a FastAPI app (routes/handlers, Pydantic schemas, Depends-based DI), modeling domain Entities/Value Objects, defining repository interfaces, implementing SQLAlchemy infrastructure adapters, or writing use cases, based on the dddpy reference.
· Configure/tune/migrate PostgreSQL, MongoDB, MySQL/MariaDB, MSSQL. Triggers: 'database', 'postgres', 'mysql', 'mongodb', 'schema', 'migration', 'pgbouncer', 'EXPLAIN'.
Execute and manage Athena SQL queries across default and federated catalogs (Glue, S3 Tables, Redshift). Triggers on phrases like: query data, run SQL, athena query, analyze table, SQL query, workgroup status, profile table, query Redshift catalog, query S3 Tables. Do NOT use for finding specific data assets (use finding-data-lake-assets), full catalog audits (use exploring-data-catalog), importing data (use ingesting-into-data-lake).
Use when building, editing, or deploying code on Val Town - the serverless Deno platform. Triggers on val.town, vals, vt CLI, std/sqlite, std/openai, std/blob, esm.town imports, .http.tsx/.cron.tsx/.email.tsx file naming, deno.json with valtown.d.ts types, or HTTP/cron/email triggers needing free OpenAI, SQLite, blob storage, or scheduled execution.
Use PlanetScale Insights and SQLCommenter-style query tags to attribute database load, identify risky queries, and prepare safe Traffic Control or schema recommendations.
Expert guidance for the SAS programming language — DATA step, PROC SQL, macro language, formats, ODS, and common procedures. Pure SAS syntax only; contains no SASjs-framework content. Use when writing, reviewing, debugging, or refactoring .sas programs, or when asked SAS language questions.
Use when the user mentions Firetiger or wants to work with their observability data — setting up Firetiger, instrumenting an app with OpenTelemetry, querying traces/logs/metrics with SQL, investigating an incident, monitoring a PR or deployment, or creating a monitoring agent. Always use this skill when the user says "Firetiger", even for simple asks — it routes to the specialized skill that carries the critical gotchas (Basic-auth ingest, DuckDB SQL over per-service tables, the @firetiger comment flow) that prevent common mistakes.
Configures the up-api .NET project's PostgreSQL connection (Npgsql, EF Core DbContext). No redeploy — config/code only. Use when the user asks for Day 1 step 4 of the CRUD drill, or asks to connect up-api to the database.
Diagnose why an application deployed by qianwenai-deploy to the Aliyun China site (aliyun.com) is unavailable or significantly slower, and perform a safe recovery only after the user explicitly confirms it. Read the .qianwenai-deploy state file in the project directory to identify ECS (and optionally RDS MySQL) resources, begin with minimal read-only diagnostics, and then propose only one recovery action at a time (starting the ECS instance, restarting the application service, or reloading Nginx), explaining the impact and obtaining confirmation before each action. Use cases: the user says the application will not open / returns 502 / cannot connect to the database, or requests a restart and confirmation that the application has recovered. Do not use: there is no .qianwenai-deploy state file; the target is the Aliyun International site (use qwencloud-operate); or the user only wants a status/cost overview (use qianwenai-observe).
Database schema design for PostgreSQL/MySQL with normalization, relationships, constraints. Use for new databases, schema reviews, migrations, or encountering missing PKs/FKs, wrong data types, premature denormalization, EAV anti-pattern.
应急管理系统权限体系开发规范。当创建新功能模块、配置菜单权限、设置数据权限时必须使用此 Skill。CX 命令执行时强制要求生成菜单权限迁移 SQL。
Database specialist covering PostgreSQL, MongoDB, Redis, and advanced data patterns for modern applications