Database

Database management and queries

Showing 2305-2328 of 4335 skills
hxk622

cellxgene-census

by hxk622

Query the CELLxGENE Census (61M+ cells) programmatically. Use when you need expression data across tissues, diseases, or cell types from the largest curated single-cell atlas. Best for population-scale queries, reference atlas comparisons. For analyzing your own data use scanpy or scvi-tools.

Automation 9 9mo ago
fellipeutaka

prisma

by fellipeutaka

Prisma ORM — type-safe database toolkit for TypeScript/Node.js. Schema-first approach with Prisma Schema Language, auto-generated type-safe client, migrations via Prisma Migrate. Use when defining database models in schema.prisma, writing CRUD queries with Prisma Client, setting up relations (1-1, 1-n, m-n), running migrations (prisma migrate dev/deploy), configuring prisma.config.ts, using raw SQL/TypedSQL, creating client extensions, or working with PostgreSQL, MySQL, SQLite, SQL Server, MongoDB, CockroachDB.

Database 5 8mo ago
Automattic

wp-phpstan

by Automattic

"Use when configuring, running, or fixing PHPStan static analysis in WordPress projects (plugins/themes/sites): phpstan.neon setup, baselines, WordPress-specific typing, and handling third-party plugin classes."

API Dev 211 9mo ago
futuregerald

better-auth-best-practices

by futuregerald

Skill for integrating Better Auth - the comprehensive TypeScript authentication framework.

Auth 5 8mo ago
futuregerald

architecture-decision-records

by futuregerald

Write and maintain Architecture Decision Records (ADRs) following best practices for technical decision documentation. Use when documenting significant technical decisions, reviewing past architectural choices, or establishing decision processes.

Code Gen 5 8mo ago
jcdendrite

sql-query-conventions

by jcdendrite

Read-path SQL conventions for raw SQL, PostgREST, and SQL-shaped ORMs. TRIGGER when: writing or modifying a SELECT query, PostgREST .from()/.select() chain, list-returning ORM call, or query-shape / pagination design. DO NOT TRIGGER when: writing write-path (INSERT/UPDATE/DELETE), DDL-only migrations, test fixtures, or document/KV stores.

Database 5 1mo ago
fellipeutaka

bun

by fellipeutaka

Bun runtime, package manager, bundler, and test runner. Use when running scripts with bun, managing packages, serving HTTP with Bun.serve, querying databases with Bun.sql/bun:sqlite/Bun.redis, shell scripting with $, using S3/file I/O, writing tests with bun:test, bundling or compiling to executable, or using any Bun-specific API (spawn, glob, semver, FFI, workers, plugins, HTMLRewriter).

Database 5 8mo ago
markus1189

elfeed

by markus1189

Search the user's Emacs elfeed RSS feed database containing curated feeds from Reddit, blogs, YouTube, GitHub releases, and newsletters. Use when the user asks about articles they've read, mentions RSS feeds or 'something I read', wants to research topics from their curated sources (programming, AI, security, NixOS, Emacs, etc.), or needs to triage unread items.

CLI Tools 5 9mo ago
eze-is

ai-partner-chat

by eze-is

基于用户画像和向量化笔记提供个性化对话。当用户需要个性化交流、上下文感知的回应,或希望 AI 记住并引用其之前的想法和笔记时使用。

Code Gen 213 11mo ago
fellipeutaka

tanstack-query

by fellipeutaka

TanStack Query (React Query) v5 best practices for data fetching, caching, mutations, and server state management. Use when building data-driven React applications, setting up query configurations, implementing mutations/optimistic updates, configuring caching strategies, integrating with SSR, or fixing v4→v5 migration errors.

Processing 5 8mo ago
futuregerald

turso-best-practices

by futuregerald

Turso and libSQL best practices for SQLite-compatible cloud database development with edge distribution, embedded replicas, and vector search.

CLI Tools 5 8mo ago
hxk622

etetoolkit

by hxk622

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

Processing 9 9mo ago
futuregerald

sql-optimization-patterns

by futuregerald

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.

Code Gen 5 8mo ago
bnadlerjr

testing-react-with-vitest

by bnadlerjr

Expert guidance for writing Vitest tests for React applications using React Testing Library. Covers component tests, custom hooks, utility tests, sociable testing philosophy, and the RTL query priority system. Favors sociable tests over heavy mocking, stubs over mocks. Use when working with .test.ts/.test.tsx files, vitest.config.ts, React Testing Library, @testing-library/user-event, @testing-library/jest-dom, renderHook, or when discussing React testing patterns, component testing, hook testing, or test organization.

Database 5 8mo ago
bnadlerjr

creating-agent-skills

by bnadlerjr

Expert guidance for creating, writing, and refining Claude Code Skills. Use when working with SKILL.md files, authoring new skills, improving existing skills, or understanding skill structure and best practices.

Database 5 8mo ago
arisng

agent-evaluator

by arisng

Deterministic custom subagent selection helper. Use when you need a reproducible, auditable decision on which custom subagents to activate for a user query (runs scripts/agent_evaluator.py).

CLI Tools 5 10mo ago
bnadlerjr

developing-elixir

by bnadlerjr

Comprehensive Elixir/Phoenix development expertise covering Phoenix controllers, routing, channels; LiveView components and real-time features; Ecto schemas, queries, migrations; OTP patterns (GenServer, Supervisor); functional domain modeling; GraphQL with Absinthe; and ExUnit testing. Use when working with .ex/.exs files, mix projects, Phoenix applications, or when the user mentions Elixir, Phoenix, Ecto, LiveView, OTP, GenServer, Supervisor, Absinthe, or ExUnit. Also use for defmodule, mix.exs, umbrella apps, or iex sessions.

Processing 5 8mo ago
jcdendrite

config-environments

by jcdendrite

Multi-environment config design, credential isolation, and secrets provisioning. TRIGGER when: designing or reviewing env-var schemes, branching-on-environment credential selection, or secret-isolation strategies. DO NOT TRIGGER when: a process legitimately holds both env values simultaneously (migrations, test harnesses) or single-environment apps.

Database 5 1mo ago
hxk622

string-database

by hxk622

Query STRING API for protein-protein interactions (59M proteins, 20B interactions). Network analysis, GO/KEGG enrichment, interaction discovery, 5000+ species, for systems biology.

API Dev 9 9mo ago
jcdendrite

plan-review

by jcdendrite

Review implementation plans before presenting to the user. A plan file in .claude/plans/ gates Write/Edit/MultiEdit/ExitPlanMode until this runs; triviality and user waivers do not release it. TRIGGER when: a plan is written or updated in .claude/plans/, or is about to be presented. DO NOT TRIGGER when: the plan lives outside .claude/plans/ (chat-level or /tmp drafts).

Auth 5 1mo ago
futuregerald

api-design-principles

by futuregerald

Master REST and GraphQL API design principles to build intuitive, scalable, and maintainable APIs that delight developers. Use when designing new APIs, reviewing API specifications, or establishing API design standards.

API Dev 5 8mo ago
fellipeutaka

drizzle-orm

by fellipeutaka

Drizzle ORM — type-safe, lightweight TypeScript ORM for SQL databases. Schema declaration, CRUD queries, joins, relations, migrations with Drizzle Kit, and database seeding. Use when defining database schemas, writing queries (select/insert/update/delete), setting up migrations, configuring drizzle.config.ts, establishing database connections, validating data with drizzle-zod/valibot, or working with PostgreSQL, MySQL, SQLite, Turso, Bun SQL, Neon, Supabase, PGlite, Expo SQLite, Cloudflare D1, PlanetScale, SingleStore, MSSQL, CockroachDB.

Code Gen 5 8mo ago
fellipeutaka

elysiajs

by fellipeutaka

Create backend with ElysiaJS, a type-safe, high-performance framework.

API Dev 5 8mo ago
futuregerald

SQLite Database Expert

by futuregerald

Expert in SQLite, libSQL, and Turso database development for desktop and web applications with focus on SQL injection prevention, migrations, FTS search, edge deployments, and secure data handling

Code Gen 5 8mo ago