Database
Database management and queries
elixir-antipatterns
by Gentleman-Programming
Core catalog of 8 critical Elixir/Phoenix anti-patterns covering error handling, separation of concerns, Ecto queries, and testing. Trigger: During Elixir code review, refactoring sessions, or when writing Phoenix/Ecto code.
backend-data-model
by parhumm
Generate data model docs with tables, constraints, indexes, retention, and migration notes. Use when designing database schemas from entities.
backend-service-implement
by parhumm
Generate service implementations with business logic from specs and scaffold stubs. Use when implementing backend services.
tsq
by arjunmahishi
Use tsq to extract structured code information with tree-sitter queries, symbols, outlines, and references across languages.
codebase-pattern-finder
by pratos
Finds similar implementations, usage examples, or existing patterns that can be modeled after. Returns concrete code examples with file:line references. Like codebase-locator but includes actual code details.
database-optimization
by ils15
Optimize SQL queries, analyze indexes, review Alembic migrations, and identify N+1 problems. Provides query execution plans, index recommendations, and migration best practices for SQLAlchemy async.
pup
by arjunmahishi
Use pup to query Datadog metrics and logs -- search, query, aggregate, list, and analyze observability data from the command line.
db
by johnlindquist
Database operations for SQLite, PostgreSQL, and MySQL. Use for queries, schema inspection, migrations, and AI-assisted query generation.
rust-knowledge-patch
by Nevaberry
This skill should be used when writing Rust code, using async closures, let chains, Edition 2024 features, new collection methods like extract_if, integer arithmetic methods, or any Rust features from 2024-2026.
text-to-sql
by kdoronin
Setup and use text-to-SQL capabilities for SQL databases (SQLite, PostgreSQL, MySQL, MariaDB, etc.). Use when: (1) User wants to query databases using natural language, (2) User asks to setup text-to-sql project, (3) User mentions extracting data from database, (4) User has .sqlite/.db file or database credentials and wants to work with data. This skill sets up project structure, extracts database schema, and enables natural language to SQL conversion.
laravel-specialist
by fefogarcia
Use when building Laravel 10+ applications requiring Eloquent ORM, API resources, or queue systems. Invoke for Laravel models, Livewire components, Sanctum authentication, Horizon queues.
fireflies
by TechNickAI
"Use when finding meeting transcripts, searching Fireflies recordings, getting action items from calls, or answering 'what was discussed in the meeting' questions"
migration-assessment
by Blazity
Use when starting a Next.js Pages Router to App Router migration, evaluating migration feasibility, or auditing codebase readiness. Run this BEFORE any other migration skill.
ingesting-data
by ancoleman
Data ingestion patterns for loading data from cloud storage, APIs, files, and streaming sources into databases. Use when importing CSV/JSON/Parquet files, pulling from S3/GCS buckets, consuming API feeds, or building ETL pipelines.
deploying-on-gcp
by ancoleman
Implement applications using Google Cloud Platform (GCP) services. Use when building on GCP infrastructure, selecting compute/storage/database services, designing data analytics pipelines, implementing ML workflows, or architecting cloud-native applications with BigQuery, Cloud Run, GKE, Vertex AI, and other GCP services.
neon-serverless
by neondatabase
Configures Neon Serverless Driver for Next.js, Vercel Edge Functions, AWS Lambda, and other serverless environments. Installs @neondatabase/serverless, sets up environment variables, and creates working API route examples with TypeScript types. Use when users need to connect their application to Neon, fetch or query data from a Neon database, integrate Neon with Next.js or serverless frameworks, or set up database access in edge/serverless environments where traditional PostgreSQL clients don't work.
deploying-on-azure
by ancoleman
Design and implement Azure cloud architectures using best practices for compute, storage, databases, AI services, networking, and governance. Use when building applications on Microsoft Azure or migrating workloads to Azure cloud platform.
neon-drizzle
by neondatabase
Creates a fully functional Drizzle ORM setup with a provisioned Neon database. Installs dependencies, provisions database credentials, configures connections, generates schemas, and runs migrations. Results in working code that can immediately connect to and query the database. Use when creating new projects with Drizzle, adding ORM to existing applications, or modifying database schemas.
neon-js
by neondatabase
Sets up the full Neon JS SDK with unified auth and PostgREST-style database queries. Configures auth client, data client, and type generation. Use when building apps that need both authentication and database access in one SDK.
neon-toolkit
by neondatabase
Creates and manages ephemeral Neon databases for testing, CI/CD pipelines, and isolated development environments. Use when building temporary databases for automated tests or rapid prototyping.
tortoise-file-finding
by daniel-ospina
Ingest a research finding into the Tortoise graph. Creates a Point, checks for existing related claims, and surfaces connection candidates.
database-migration-skill
by darellchua2
Database schema evolution with Prisma, Alembic, Django — workflows, rollback, zero-downtime, seed data, migration testing.
arcgis-layers
by SaschaBrunnerCH
Add and manage data layers in ArcGIS maps. Use for FeatureLayer, TileLayer, SceneLayer, GeoJSONLayer, and all other layer types. Covers layer configuration, queries, and management.
civiltekk-python-backend-skill
by darellchua2
Python backend engineering — scaffold FastAPI/Django/Flask projects (layout, dependency injection, config, virtual environments, pyproject.toml), package apps and libraries (Poetry, uv, setuptools, hatch, dependency management, PyPI publishing), and apply backend patterns (Pydantic v2 conventions, layered FastAPI architecture, ORM pitfalls N+1/migration syntax, defensive coding, multi-tenant isolation).