SQL 資料庫
1003 skills in 資料庫 > SQL 資料庫
agent-observability
Real-time observability dashboard for multi-agent Claude Code sessions.Visualize agent interactions, tool usage, and session flows in real-time through a web dashboard. Track multiple agents running in parallel with swim lane visualization, event filtering, and live charts.**Key Features:**- 🔴 Real-time event streaming via WebSocket- 📊 Agent swim lanes showing parallel execution- 🔍 Event filtering by agent, session, event type- 📈 Live charts for tool usage patterns- 💾 Filesystem-based (no database required)**Inspired by [@indydevdan](https://github.com/indydevdan)**'s work on multi-agent observability.**Our approach:** Filesystem + in-memory streaming vs. indydevdan's SQLite database approach.
databases
Game data persistence with player profiles, leaderboards, inventory systems using Redis and PostgreSQL
remediation-injection
Security fix patterns for injection vulnerabilities (SQL, Command, XSS). Provides language-specific code examples showing vulnerable and secure implementations.
orchestrator-observability
Monitor orchestrator performance, track prompt enhancement scores, detect workflow bottlenecks, and export metrics to PostgreSQL with WebSocket broadcasting. Keywords - monitoring, metrics, performance, observability, track metrics, workflow bottleneck, performance monitoring, orchestrator metrics
active-record-db
This skill should be used when the user asks about Active Record models, database migrations, queries, associations (belongs_to, has_many, has_one, has_and_belongs_to_many), validations, callbacks, scopes, database schema design, SQL optimization, N+1 queries, eager loading, joins, or database-specific features (PostgreSQL, MySQL, SQLite). Also use when discussing ORM patterns, data modeling, or database best practices. Examples:
postgresql-performance
Enforces PostgreSQL best practices for Django models and migrations. This skill should be used when creating models, adding fields, or working with database migrations to ensure proper indexes on filtered fields and migration safety.
better-auth-python
Better Auth JWT verification for Python/FastAPI backends. Use when integrating Python APIs with a Better Auth TypeScript server via JWT tokens. Covers JWKS verification, FastAPI dependencies, SQLModel/SQLAlchemy integration, and protected routes.
neon-postgres
Neon PostgreSQL serverless database - connection pooling, branching, serverless driver, and optimization. Use when deploying to Neon or building serverless applications.
story-tree
Use when user says "update story tree", "show story tree", "show me a map", "story map", "tree diagram", "show stories", "view stories", "list stories", or asks for story visualization or tree status - autonomously maintains hierarchical story backlog by analyzing git commits, identifying under-capacity nodes, and coordinating story generation to fill gaps. Works with SQLite database using closure table pattern, prioritizes shallower nodes first, and tracks implementation status through commit analysis.
postgres-rls
MANDATORY when touching auth tables, tenant isolation, RLS policies, or multi-tenant database code - enforces Row Level Security best practices and catches common bypass vulnerabilities
laneweaver-database-design
Design PostgreSQL 17 schemas for laneweaverTMS using Supabase conventions - UUIDs, ENUMs, audit trails, soft deletes, triggers, functions, views, and atomic migration patterns.
using-sqlite
Use when working with SQLite databases in DataPeeker analysis sessions - querying data, importing CSVs, exploring schemas, formatting output, or optimizing performance. Provides task-oriented guidance for effective SQLite CLI usage in data analysis workflows.
moai-platform-supabase
Supabase specialist covering PostgreSQL 16, pgvector, RLS, real-time subscriptions, and Edge Functions. Use when building full-stack apps with Supabase backend.
agentuity-cli-cloud-db-sql
Execute SQL query on a database. Requires authentication. Use for Agentuity cloud platform operations
binora-backend-performance-orchestrator
META-SKILL ORCHESTRATOR - ALWAYS-ACTIVE. Orchestrates 100% Binora Backend workflows (Django 5.0+DRF 3.14+PostgreSQL multi-tenant) through 6-phase execution (Pre-Analysis, Request Analysis, Workflow Planning, Skill Coordination, Tool Optimization, Quality Assurance). Enforces P0 CRITICAL rules (NO manual tenant_id, service layer mandatory, YOLO comments). Selects optimal model (Sonnet/Haiku). MCP-first strategy (Context7/db/github/sequential-thinking). Target: 3-5x speedup, 95%+ P1 compliance, <500 token overhead.
drupal-standards
Automatically applies Drupal coding standards when developing PHP modules, JavaScript, CSS, SQL queries, Twig templates, or YAML configs. Activates when creating/editing .php, .js, .css, .sql, .twig, .yml files or when user mentions "module", "query", "template", "form", or "custom code".
agent-observability
Real-time observability dashboard for multi-agent Claude Code sessions.Visualize agent interactions, tool usage, and session flows in real-time through a web dashboard. Track multiple agents running in parallel with swim lane visualization, event filtering, and live charts.**Key Features:**- 🔴 Real-time event streaming via WebSocket- 📊 Agent swim lanes showing parallel execution- 🔍 Event filtering by agent, session, event type- 📈 Live charts for tool usage patterns- 💾 Filesystem-based (no database required)**Inspired by [@indydevdan](https://github.com/indydevdan)**'s work on multi-agent observability.**Our approach:** Filesystem + in-memory streaming vs. indydevdan's SQLite database approach.
working-with-sqlite
Preferences and tricks for working with SQLite databases
visidata
VisiData is a terminal spreadsheet for exploring data. Use it instead of one-off jq/SQL queries. Check --help first, then use with tmux for programmatic control.
defi-protocols
Master DeFi protocol development including AMMs, lending, yield, and oracles