Database

Database management and queries

Showing 745-768 of 3624 skills
yonatangross

memory-fabric

by yonatangross

Knowledge graph memory orchestration - entity extraction, query parsing, deduplication, and cross-reference boosting. Use when designing memory orchestration.

Analytics 180 3mo ago
jimmc414

alphafold-database

by jimmc414

"Access AlphaFold's 200M+ AI-predicted protein structures. Retrieve structures by UniProt ID, download PDB/mmCIF files, analyze confidence metrics (pLDDT, PAE), for drug discovery and structural biology."

API Dev 530 6mo ago
jaechang-hits

gnomad-database

by jaechang-hits

"Query gnomAD v4 population variant frequencies via GraphQL API. Retrieve allele counts and frequencies stratified by ancestry group (AFR, AMR, EAS, NFE, SAS, FIN, ASJ, MID), gene-level constraint metrics (pLI, LOEUF, missense z-score), and read depth coverage. Identify variants with low population frequency or under evolutionary constraint. For clinical pathogenicity classifications use clinvar-database; for GWAS associations use gwas-database."

API Dev 192 3mo ago
jimmc414

bioservices

by jimmc414

"Primary Python tool for 40+ bioinformatics services. Preferred for multi-database workflows: UniProt, KEGG, ChEMBL, PubChem, Reactome, QuickGO. Unified API for queries, ID mapping, pathway analysis. For direct REST control, use individual database skills (uniprot-database, kegg-database)."

Processing 530 6mo ago
yonatangross

database-patterns

by yonatangross

Database design and migration patterns for Alembic migrations, schema design (SQL/NoSQL), and database versioning. Use when creating migrations, designing schemas, normalizing data, managing database versions, or handling schema drift.

Database 180 3mo ago
softaworks

mermaid-diagrams

by softaworks

Comprehensive guide for creating software diagrams using Mermaid syntax. Use when users need to create, visualize, or document software through diagrams including class diagrams (domain modeling, object-oriented design), sequence diagrams (application flows, API interactions, code execution), flowcharts (processes, algorithms, user journeys), entity relationship diagrams (database schemas), C4 architecture diagrams (system context, containers, components), state diagrams, git graphs, pie charts, gantt charts, or any other diagram type. Triggers include requests to "diagram", "visualize", "model", "map out", "show the flow", or when explaining system architecture, database design, code structure, or user/application flows.

Auth 2K 4mo ago
jmagly

tot-exploration

by jmagly

@.aiwg/research/findings/REF-020-tree-of-thoughts.md - Research foundation

Agents 143 3mo ago
jmagly

decision-support

by jmagly

Trade-off catalog: docs/common-tradeoffs.md

Database 143 5mo ago
jmagly

architecture-evolution

by jmagly

Architecture diagram: .aiwg/architecture/diagrams/

Code Gen 143 5mo ago
jmagly

config-validator

by jmagly

Migration guides: docs/config-migrations.md

Database 143 5mo ago
akin-ozer

logql-generator

by akin-ozer

Comprehensive toolkit for generating best practice LogQL (Loki Query Language) queries following current standards and conventions. Use this skill when creating new LogQL queries, implementing log analysis dashboards, alerting rules, or troubleshooting with Loki.

Processing 226 3mo ago
mcouthon

critic

by mcouthon

"Challenge assumptions and probe reasoning using adversarial thinking. Use when asked to find weaknesses, challenge a design, identify edge cases, or stress-test an approach. Triggers on: 'use critic mode', 'challenge this', 'find weaknesses', 'what could go wrong', 'critic', 'devil's advocate', 'poke holes', 'stress test', 'what am I missing', '5 whys'. Read-only mode - questions and probes but doesn't provide solutions."

Processing 70 3mo ago
mcouthon

critic

by mcouthon

"Challenge assumptions and probe reasoning using adversarial thinking. Use when asked to find weaknesses, challenge a design, identify edge cases, or stress-test an approach. Triggers on: 'use critic mode', 'challenge this', 'find weaknesses', 'what could go wrong', 'critic', 'devil's advocate', 'poke holes', 'stress test', 'what am I missing', '5 whys'. Read-only mode - questions and probes but doesn't provide solutions."

Processing 70 3mo ago
render-oss

render-migrate-from-heroku

by render-oss

"Migrate from Heroku to Render by reading local project files and generating equivalent Render services. Triggers: any mention of migrating from Heroku, moving off Heroku, Heroku to Render migration, or switching from Heroku. Reads Procfile, dependency files, and app config from the local repo. Optionally uses Heroku MCP to enrich with live config vars, add-on details, and dyno sizes. Uses Render MCP or Blueprint YAML to create services."

Processing 52 3mo ago
bitwarden

writing-server-code

by bitwarden

Bitwarden server code conventions for C# and .NET. Use when working in the server repo, creating commands, queries, services, or API endpoints.

API Dev 110 3mo ago
bitwarden

implementing-dapper-queries

by bitwarden

Implementing Dapper repository methods and stored procedures for MSSQL at Bitwarden. Use when creating or modifying Dapper repositories, writing stored procedures, or working with MSSQL-specific data access in the server repo.

Code Gen 110 3mo ago
AzureCosmosDB

cosmosdb-best-practices

by AzureCosmosDB

Azure Cosmos DB performance optimization and best practices guidelines for NoSQL, partitioning, queries, and SDK usage. Use when writing, reviewing, or refactoring code that interacts with Azure Cosmos DB, designing data models, optimizing queries, or implementing high-performance database operations.

Processing 31 3mo ago
yonatangross

domain-driven-design

by yonatangross

Domain-Driven Design tactical patterns for complex business domains. Use when modeling entities, value objects, domain services, repositories, or establishing bounded contexts.

Database 180 3mo ago
yonatangross

distributed-systems

by yonatangross

Distributed systems patterns for locking, resilience, idempotency, and rate limiting. Use when implementing distributed locks, circuit breakers, retry policies, idempotency keys, token bucket rate limiters, or fault tolerance patterns.

Caching 180 3mo ago
Xuanwo

xurl

by Xuanwo

Use xurl to read, discover, and write AI agent conversations through agents:// URIs, and read skills through skills:// URIs.

CLI Tools 349 3mo ago
ccheney

postgres-drizzle

by ccheney

Proactively apply when creating APIs, backends, or data models. Triggers on PostgreSQL, Postgres, Drizzle, database, schema, tables, columns, indexes, queries, migrations, ORM, relations, joins, transactions, SQL, drizzle-kit, connection pooling, N+1, JSONB, RLS. Use when writing database schemas, queries, migrations, or any database-related code. PostgreSQL and Drizzle ORM best practices.

Processing 50 3mo ago
wcygan

postgres

by wcygan

PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.

CLI Tools 192 3mo ago
wcygan

deep-dive

by wcygan

Deep dive into a codebase to understand specific topics, patterns, or implementations. Spawns parallel agents with distinct investigation strategies (breadth-first mapping, depth-first tracing, optional history/boundary analysis) then synthesizes findings into a layered summary. Use for understanding how something works, exploring unfamiliar code, or building a mental model of a large system. Keywords: deep dive, explore, understand, how does, architecture, codebase exploration, trace, investigate, mental model

Agents 192 3mo ago
wcygan

mysql

by wcygan

Plan and review MySQL/InnoDB schema, indexing, query tuning, transactions, and operations. Use when creating or modifying MySQL tables, indexes, or queries; diagnosing slow/locking behavior; planning migrations; or troubleshooting replication and connection issues. Load when using a MySQL database.

Comments 192 3mo ago