Database

Database management and queries

Showing 625-648 of 4338 skills
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 298 8mo 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 298 8mo ago
sanity-io

sanity-best-practices

by sanity-io

Comprehensive Sanity development best practices covering integration guides (Next.js, Nuxt, Astro, Remix, SvelteKit, Hydrogen), GROQ performance, schema design, Visual Editing, images, Portable Text, page builders, Studio configuration, TypeGen, localization, and migrations. Use this skill when building, reviewing, or optimizing Sanity applications.

Database 194 8mo ago
mohitagw15856

rfc-writer

by mohitagw15856

"Write an engineering RFC (Request for Comments) for a technical decision, architectural change, or significant implementation approach. Use when asked to write an RFC, document a technical proposal, create a design doc, write an architecture decision for review, or produce a technical specification for team feedback. Produces a complete RFC document covering problem statement, motivation, proposed solution, alternatives rejected, implementation plan, migration plan, security and performance implications, observability changes, rollout plan, and open questions."

Comments 1.5K 4mo ago
BasedHardware

omi-backend-patterns

by BasedHardware

"Omi backend patterns conversation processing memory extraction chat system LangGraph FastAPI Firestore Pinecone Redis"

API Dev 13.8K 9mo ago
existential-birds

exunit-code-review

by existential-birds

Reviews ExUnit test code for proper patterns, boundary mocking with Mox, and test adapter usage. Use when reviewing _test.exs files or test helper configurations.

Code Review 84 8mo ago
existential-birds

go-data-persistence

by existential-birds

Data persistence patterns in Go covering raw SQL with sqlx/pgx, ORMs like Ent and GORM, connection pooling, migrations with golang-migrate, and transaction management. Use when implementing database access, designing repositories, or managing schema migrations.

Database 84 8mo ago
existential-birds

llm-judge

by existential-birds

LLM-as-judge methodology for comparing code implementations across repositories. Scores implementations on functionality, security, test quality, overengineering, and dead code using weighted rubrics. Used by /beagle:llm-judge command.

Database 84 8mo ago
jimmc414

hmdb-database

by jimmc414

"Access Human Metabolome Database (220K+ metabolites). Search by name/ID/structure, retrieve chemical properties, biomarker data, NMR/MS spectra, pathways, for metabolomics and identification."

Processing 602 11mo ago
pmndrs

koota

by pmndrs

Real-time ECS state management for TypeScript and React. Use when the user mentions koota, ECS, entities, traits, queries, or building data-oriented applications.

Processing 759 8mo ago
PostHog

debugging-mcp-analytics

by PostHog

Debug, support, and build PostHog MCP Analytics — product analytics for MCP servers (the @posthog/mcp and posthog.mcp SDKs plus the mcp_analytics product). Use when MCP analytics data looks wrong or missing ("events aren't showing", "intent clusters are empty", "sessions are missing", "per-tool numbers look wrong"), when writing queries over $mcp_* events by hand, or when doing feature work on the SDKs, the dashboard and its query runners, the self-instrumented MCP server, the wizard mcp-analytics install command, or the in-app onboarding. Covers the repo map, the $mcp_* vocabulary and where each property comes from, the rules that silently corrupt metrics when ignored, the end-to-end pipeline and where each stage breaks, and which repo to change. For reading the data rather than fixing it, prefer the exploring-mcp-* and improving-mcp-tools skills.

Analytics 40.4K 1mo ago
PostHog

profiling-slow-api-endpoints

by PostHog

Profiles slow PostHog API endpoints when the main cost is in Postgres or Python. Use when a screen, picker, or list is slow; a Django endpoint has high tail latency; a query plan changes with tenant size; or a proposed database fix needs production evidence. Covers APM traces, safe production EXPLAIN, representative measurements, implementation choices, tests, rollout, and post-deploy verification. For ClickHouse or HogQL latency, use optimizing-clickhouse-and-hogql-queries instead.

Database 40.4K 1mo ago
mohitagw15856

database-schema-design

by mohitagw15856

"Document or design a database schema with entity relationships, table definitions, constraints, indexes, and access patterns. Use when asked to design a database, document an existing schema, model entities and relationships, define table structures, plan an index strategy, or produce a data model for review. Produces a structured schema document covering an ER diagram, table DDL definitions, index strategy, access pattern analysis, normalization decisions, and migration notes."

Database 1.5K 4mo ago
jimmc414

cellxgene-census

by jimmc414

"Query CZ CELLxGENE Census (61M+ cells). Filter by cell type/tissue/disease, retrieve expression data, integrate with scanpy/PyTorch, for population-scale single-cell analysis."

Automation 601 11mo ago
jimmc414

ensembl-database

by jimmc414

"Query Ensembl genome database REST API for 250+ species. Gene lookups, sequence retrieval, variant analysis, comparative genomics, orthologs, VEP predictions, for genomic research."

API Dev 601 11mo ago
jimmc414

etetoolkit

by jimmc414

"Phylogenetic tree toolkit (ETE). Tree manipulation (Newick/NHX), evolutionary event detection, orthology/paralogy, NCBI taxonomy, visualization (PDF/SVG), for phylogenomics."

Processing 601 11mo ago
jimmc414

fda-database

by jimmc414

"Query openFDA API for drugs, devices, adverse events, recalls, regulatory submissions (510k, PMA), substance identification (UNII), for FDA regulatory data analysis and safety research."

Database 601 11mo ago
jimmc414

chembl-database

by jimmc414

"Query ChEMBL's bioactive molecules and drug discovery data. Search compounds by structure/properties, retrieve bioactivity data (IC50, Ki), find inhibitors, perform SAR studies, for medicinal chemistry."

Processing 601 11mo ago
windmill-labs

write-script-mssql

by windmill-labs

MUST use when writing MS SQL Server queries.

CLI Tools 18.3K 3mo ago
windmill-labs

write-script-graphql

by windmill-labs

MUST use when writing GraphQL queries.

CLI Tools 18.3K 3mo ago
windmill-labs

write-script-bun

by windmill-labs

MUST use when writing TypeScript scripts. Bun is the default and preferred TypeScript runtime — pick it for TypeScript unless the script specifically needs Deno.

Automation 18.3K 2mo ago
windmill-labs

resources

by windmill-labs

MUST use when managing resources.

Database 18.3K 3mo ago
InsForge

insforge-cli

by InsForge

Create and manage InsForge projects using the CLI. Handles authentication, project setup, database management, edge functions, storage, deployments, and secrets. For writing application code with the InsForge SDK, use the insforge (SDK) skill instead.

Code Gen 41 8mo ago
prowler-cloud

prowler-attack-paths-query

by prowler-cloud

Creates Prowler Attack Paths openCypher queries for graph analysis (compatible with Neo4j and Neptune). Trigger: When creating or updating Attack Paths queries that detect privilege escalation paths, network exposure, or security misconfigurations in cloud environments.

Cloud 15.1K 8mo ago