All categories
Databases
SQL, NoSQL, schema design, migrations, ORMs, and database operations
- 4,315
- 180
Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.
Open in full browserBrowse databases skills
Showing 769–792 of 4,315 skills
- Sql ExplainInterpret EXPLAIN / query plans (MySQL, PostgreSQL, or pasted plan text): access types, indexes, and tuning hints.Votes: 0GitHub stars: 22
- Mysql ExplainMySQL EXPLAIN query analyzer: supports EXPLAIN, EXPLAIN ANALYZE, EXPLAIN FORMAT. Shows query execution plan, index usage, and estimated costs.Votes: 0GitHub stars: 22
- MongodbQuery MongoDB databases, collections, and documentsVotes: 0GitHub stars: 22
- Es QueryElasticsearch operations: search, count, mapping, indices, cluster health, aliases. Supports basic auth and API key.Votes: 0GitHub stars: 22
- Db QueryRead-only database queries for MySQL and PostgreSQL inspectionVotes: 0GitHub stars: 22
- Supabase Postgres Best PracticesSupabase 的 Postgres 性能优化和最佳实践。在编写、审查或优化 Postgres 查询、模式设计或数据库配置时使用此技能。Votes: 0GitHub stars: 8
- Sql Queries跨所有主要数据仓库方言（Snowflake、BigQuery、Databricks、PostgreSQL 等）编写正确、高性能的 SQL。在编写查询、优化慢速 SQL、在方言之间进行转换或使用 CTE、窗口函数或聚合构建复杂的分析查询时使用。Votes: 0GitHub stars: 8
- Database Query Optimization>Votes: 0GitHub stars: 8
- Database Migrations数据库迁移的最佳实践，涵盖架构更改、数据迁移、回滚以及跨 PostgreSQL、MySQL 和常用 ORM（Prisma、Drizzle、Kysely、Django、TypeORM、golang-migrate）的零停机部署。Votes: 0GitHub stars: 8
- Architecture Patterns架构模式 - 后端架构模式，用于构建可维护、可测试的系统：整洁架构、六边形架构和领域驱动设计。适用于设计新后端系统、重构单体、建立架构标准、创建可测试代码库或规划微服务分解。Votes: 0GitHub stars: 8
- Orpc Mini Server Side ClientHow to turn a procedure into a callable function in Mini oRPC.Votes: 0GitHub stars: 8
- Orpc Migrate From TrpcA comprehensive guide to migrate your tRPC application to oRPC.Votes: 0GitHub stars: 8
- Option To PurchaseDrafts Option to Purchase Real Estate agreements granting an optionee the exclusive right to buy property within a specified timeframe. Trigger when user needs a real estate option agreement, purchase option, right-to-purchase contract, or option-to-buy instrument for residential transactions.Votes: 0GitHub stars: 41
- Opinion SummarySummarizes U.S. transactional legal opinions into executive-ready briefs preserving issues, analysis, conclusions, qualifications, and key authorities. Triggers when asked to summarize a legal opinion, opinion memorandum, legal analysis memo, or produce an executive opinion recap.Votes: 0GitHub stars: 41
- Judgment SummaryProduces structured U.S. litigation judgment summaries from court opinions or final orders. Use when summarizing a judgment, opinion, final decision, post-trial ruling, appeal outcome, or case disposition brief. Covers caption, procedural history, facts, issues, standards of review, holdings, precedent treatment, concurrences/dissents, disposition, and practical implications with pinpoint citations.Votes: 0GitHub stars: 41
- Structuring Term Loan B FacilitiesDesigns institutional term loan structures with amortization schedules, repricing protection, and soft call provisions. Use when structuring TLBs, analyzing institutional loan terms, or comparing bank vs institutional debt.Votes: 0GitHub stars: 41
- Lakebase Change Data Feed (CDF) — Sync Postgres to Unity CatalogLakebase Change Data Feed (CDF) captures every `INSERT`, `UPDATE`, and `DELETE` on Lakebase Postgres tables via the write-ahead log (WAL) and stores them as append-only rows in Unity Catalog managed Delta tables. Changes are batched and flushed approximately every ~15 seconds.Votes: 0GitHub stars: 6
- Data Analyst Cn数据分析助手 - 数据清洗、统计分析、可视化建议。适合：数据分析师、产品经理、运营。Votes: 0GitHub stars: 2
- Postgresql DevelopmentUse when building, debugging, or evaluating CloudBase PostgreSQL / CloudBase PG / PG mode apps, including Postgres schema setup, queryPgDatabase/managePgDatabase, JS SDK v3 app.rdb() CRUD/RPC, PG HTTP API fallback, RLS-style permissions, username-password auth, and Web CMS/admin CRUD flows backed by CloudBase PG.Votes: 0GitHub stars: 2
- Data Model CreationOptional advanced tool for complex data modeling. For simple MySQL table creation, use relational-database-tool directly; for PostgreSQL / CloudBase PG schema work, use postgresql-development.Votes: 0GitHub stars: 2
- Cloudbase Code ReviewCode review and validation for CloudBase projects. After writing code for Web / miniprogram / CloudRun / cloud-function projects, call this skill to check for known pitfalls — auth guard misuse, missing database tables, RLS misconfiguration, storage domain setup, and SDK API misuse. Supports automated lint scripts (regex-based) + LLM semantic review.Votes: 0GitHub stars: 2
- Dsh IngestRebuild the DSH node's persistent knowledge state. Runs register-claude.py to (re)create the dome.db schema and upsert agents/skills/tools/stack rows, then runs ingest.py to re-index kb/, logs/, docs, and agent core source into ChromaDB's dome-kb collection, then runs pre-spore-verify.py to confirm all 7 skill modules load and the akashic write+query roundtrip works. Idempotent — safe to run any time.Votes: 0GitHub stars: 4
- Performance TunerPerformance optimization, profiling, caching strategies, lazy loading, bundle optimization, and monitoring. Use when optimizing application performance, reducing bundle size, implementing caching, or analyzing bottlenecks.Votes: 0GitHub stars: 4
- Migration SpecialistDatabase migrations, schema evolution, data transformation, and zero-downtime deployments. Use when creating migrations, evolving database schema, transforming data, or planning deployment strategies.Votes: 0GitHub stars: 4