SQL 資料庫
1003 skills in 資料庫 > SQL 資料庫
sqldown
Bidirectional markdown ↔ SQLite conversion with column limit protection and smart section extraction. Import with Python, query with sqlite3.
api-security
API security best practices and common vulnerability prevention. Enforces security checks for authentication, input validation, SQL injection, XSS, and OWASP Top 10 vulnerabilities. Use when building or modifying APIs.
admin-infra-oci
Deploys infrastructure on Oracle Cloud Infrastructure (OCI) with ARM64 instances (Always Free tier eligible).Handles compartments, VCNs, subnets, security lists, and compute instances.Use when: setting up Oracle Cloud infrastructure, deploying ARM64 instances, troubleshooting OUT_OF_HOST_CAPACITY errors, optimizing for Always Free tier.Keywords: oracle cloud, OCI, ARM64, VM.Standard.A1.Flex, Always Free tier, OUT_OF_HOST_CAPACITY, oci compartment, oci vcn
wasp-database
Complete database migration workflow and schema management for Wasp projects. Use when modifying schema.prisma, running migrations, or working with database models. Includes MANDATORY restart requirement and PostgreSQL setup.
oracle-consultation
Use before invoking Oracle to ensure appropriate usage of this expensive reasoning resource
dokploy-skill
Dokploy 셀프호스팅 PaaS 플랫폼의 전체 관리 스킬. SSH 및 API를 통한 서버 관리,애플리케이션 배포, Docker Compose/Swarm 관리, 데이터베이스(PostgreSQL, MySQL, MongoDB, Redis) 관리,Traefik 리버스 프록시 설정, SSL 인증서(Let's Encrypt, Cloudflare Origin CA), 도메인 설정,볼륨 백업/복원, 컨테이너 모니터링, 서버 문제 해결 및 디버깅을 지원합니다.이 스킬 사용 시점:(1) "Dokploy", "dokploy" 언급 시(2) 애플리케이션 배포/재배포 요청(3) Docker Compose 또는 Swarm 관련 작업(4) 도메인 설정, SSL 인증서, HTTPS 설정(5) Traefik 설정 확인/수정, 502 에러, 도메인 접속 문제(6) 데이터베이스 생성, 백업, 복원(7) 볼륨 백업/복원, S3 연동(8) 컨테이너 로그 확인, 서버 상태 점검(9) 서버 유지보수, Dokploy 업데이트(10) 빌드 타입 선택 (Nixpacks, Dockerfile, Buildpack)
backend-rust
Modern Rust backend with Axum, SQLx, tokio + CI/CD automation.Use when: building Rust APIs, high-performance services, or needing build/test/lint/audit automation.Triggers: "axum", "rust backend", "rust api", "sqlx", "tokio", "cargo build","cargo test", "clippy", "rustfmt", "cargo-audit", "cross-compile", "rust ci","release build", "rust security", "shuttle", "actix".
kysely
Kysely type-safe SQL query builder - End-to-end type safety from schema to queries, migrations, transactions, plugins
supabase-dev
Supabase development guidelines for Next.js applications. Use when working with Supabase Auth SSR, database migrations, RLS policies, database functions, Edge Functions, or declarative schema management. Covers @supabase/ssr patterns, PostgreSQL best practices, and Deno-based Edge Functions.
mastering-gcloud-commands
Expert-level Google Cloud CLI (gcloud) skill for managing GCP resources. Use when workingwith "gcloud commands", "cloud run deploy", "alloydb", "cloud sql", "workload identityfederation", "iam permissions", "vpc networking", "secret manager", or "artifact registry".Covers installation, authentication, IAM, Cloud Run, Cloud Storage, VPC, AlloyDB, Firebase,and CI/CD integration with GitHub Actions and Cloud Build.
managing-supabase-databases
Creating and managing Supabase PostgreSQL databases for StickerNest. Use when the user asks to create tables, add columns, write migrations, design schemas, implement RLS policies, optimize indexes, partition tables, or scale the database. Covers enterprise-grade security, performance optimization, and social features.
postgres-query-optimization
PostgreSQL query optimization and performance tuning reference. Use when analyzing slow queries, interpreting EXPLAIN output, optimizing indexes, or troubleshooting database performance issues.
sql-development
Design efficient database schemas, write optimized queries with proper indexes, and manage data operations following best practices
sql-optimization-patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
sqlite-integration-for-beginners
Add SQLite database to Flask or Sinatra app with beginner-friendly code examples and teaching comments
neon-database
Use when working with Neon serverless PostgreSQL database. Covers database setup, CLI commands, Drizzle ORM integration, schema migrations, connection pooling, and user data storage patterns for authentication and chat history.
backend
FastAPI, SQLModel, async services for Pulse Radar backend development.
happiness-dashboard
Evidence framework data dashboard with DuckDB. Write SQL in markdown to create visualizations.
hummingbird-api
Standalone Hummingbird backend API with Fluent/PostgreSQL/Redis
impl-repository
Implementar repositórios de acesso a dados em repositories/. Use quando criar repository, acesso a banco, queries SQL, ou persistência.