Database

Database management and queries

Showing 2137-2160 of 3628 skills
DoubleslashSE

error-patterns

by DoubleslashSE

Error recognition and diagnosis patterns for infrastructure troubleshooting. Use when identifying, categorizing, or resolving errors across platforms.

Database 3 4mo 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 3 3mo ago
fellipeutaka

elysiajs

by fellipeutaka

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

API Dev 3 3mo ago
peopleforrester

code-reviewer

by peopleforrester

Systematic code review for pull requests and code changes. Use when the user asks for a code review, PR review, or wants feedback on code quality. Provides structured feedback on correctness, security, performance, and maintainability.

Code Review 3 4mo ago
ngxtm

angular-migration

by ngxtm

"Migrate from AngularJS to Angular using hybrid mode, incremental component rewriting, and dependency injection updates. Use when upgrading AngularJS applications, planning framework migrations, or ..."

Database 7 3mo ago
thechandanbhagat

docs

by thechandanbhagat

Generate documentation, API docs, README files, and code comments. Use for creating or improving project documentation.

API Dev 7 4mo ago
troykelly

postgres-rls

by troykelly

MANDATORY when touching auth tables, tenant isolation, RLS policies, or multi-tenant database code - enforces Row Level Security best practices and catches common bypass vulnerabilities

Database 7 5mo ago
troykelly

postgis

by troykelly

MANDATORY when working with geographic data, spatial queries, geometry operations, or location-based features - enforces PostGIS 3.6.1 best practices including ST_CoverageClean, SFCGAL 3D functions, and bigint topology

Code Gen 7 5mo ago
thechandanbhagat

json

by thechandanbhagat

Parse, validate, transform, and manipulate JSON data. Use for JSON operations, schema validation, and data transformation.

Processing 7 4mo ago
dtsong

ai-data-integration

by dtsong

"Use this skill when connecting AI or LLMs to data platforms. Covers MCP servers for warehouses, natural-language-to-SQL, embeddings for data discovery, LLM-powered enrichment, and AI agent data access patterns. Common phrases: \"text-to-SQL\", \"MCP server for Snowflake\", \"LLM data enrichment\", \"AI agent access\". Do NOT use for general data integration (use data-integration) or dbt modeling (use dbt-transforms)."

Processing 10 3mo ago
vanman2024

result-backend-patterns

by vanman2024

Result backend configuration patterns for Celery including Redis, Database, and RPC backends with serialization, expiration policies, and performance optimization. Use when configuring result storage, troubleshooting result persistence, implementing custom serializers, migrating between backends, optimizing result expiration, or when user mentions result backends, task results, Redis backend, PostgreSQL results, result serialization, or backend migration.

Caching 10 6mo ago
dtsong

data-observability

by dtsong

"Use this skill when implementing monitoring, alerting, and incident response for data pipelines. Covers freshness monitoring, volume anomaly detection, schema change detection, alerting patterns, and incident response workflows. Common phrases: \"data freshness\", \"pipeline monitoring\", \"data anomaly\", \"schema drift\", \"data alerting\", \"incident response\", \"data observability\", \"stale data\". Do NOT use for writing dbt models (use dbt-transforms), pipeline scheduling (use data-pipelines), or data quality testing as deliverables (use data-testing)."

Processing 10 3mo ago
samhvw8

databases

by samhvw8

"MongoDB and PostgreSQL database administration. Databases: MongoDB (document store, aggregation, Atlas), PostgreSQL (relational, SQL, psql). Capabilities: schema design, query optimization, indexing, migrations, replication, sharding, backup/restore, user management, performance analysis. Actions: design, query, optimize, migrate, backup, restore, index, shard databases. Keywords: MongoDB, PostgreSQL, SQL, NoSQL, BSON, aggregation pipeline, Atlas, psql, pgAdmin, schema design, index, query optimization, EXPLAIN, replication, sharding, backup, restore, migration, ORM, Prisma, Mongoose, connection pooling, transactions, ACID. Use when: designing database schemas, writing complex queries, optimizing query performance, creating indexes, performing migrations, setting up replication, implementing backup strategies, managing database permissions, troubleshooting slow queries."

Processing 10 6mo ago
founderjourney

senior-recruiter-simulator

by founderjourney

Simula un reclutador senior para practicar entrevistas. Usar cuando el usuario quiera entrenar para entrevistas, practicar respuestas, recibir feedback sobre sus answers, o hacer mock interviews. Activa con palabras como mock interview, practicar entrevista, simular reclutador, entrevistame, hazme preguntas, evalua mi respuesta, feedback de entrevista. Especializado en roles Senior Full-Stack Developer, SaaS, y posiciones remotas.

Database 10 4mo ago
vanman2024

managed-databases

by vanman2024

DigitalOcean Managed Database provisioning and connection patterns

Caching 10 4mo ago
agoodway

understand

by agoodway

Multi-specialist collaborative analysis to understand how features, functions, or components work

Database 10 4mo ago
samhvw8

better-auth

by samhvw8

"TypeScript authentication framework (framework-agnostic). Features: email/password, OAuth (Google, GitHub, Discord), 2FA (TOTP, SMS), passkeys/WebAuthn, session management, RBAC, rate limiting, database adapters. Actions: implement, configure, secure authentication systems. Keywords: Better Auth, authentication, authorization, OAuth, email/password, 2FA, MFA, TOTP, passkeys, WebAuthn, session management, RBAC, rate limiting, database adapter, TypeScript auth, social login, Google auth, GitHub auth, Discord auth, email verification, password reset. Use when: implementing TypeScript auth, adding OAuth providers, setting up 2FA/MFA, managing sessions, configuring RBAC, building secure auth systems."

Auth 10 6mo ago
founderjourney

saas-architecture-deep-dive

by founderjourney

Dominio de arquitectura SaaS para Senior Full-Stack Developer. Usar cuando el usuario necesite explicar arquitectura SaaS, multi-tenancy, disenar sistemas escalables, evaluar trade-offs arquitectonicos, o preparar respuestas sobre diseño de sistemas. Activa con palabras como SaaS, multi-tenant, arquitectura, escalabilidad, tenant isolation, subscription, billing, feature flags, scaling. Especializado en plataformas como HostelOS y Digitaliza.

Processing 10 4mo ago
netcmcc

aliyun-dns

by netcmcc

Manage Alibaba Cloud (Aliyun) domain DNS records (query, add, update, delete). Use this skill when users need to configure DNS, set up subdomains, or manage domain resolution for deployments. Supports A, CNAME, and other record types.

CLI Tools 10 3mo ago
Tyler-R-Kendrick

dotnet

by Tyler-R-Kendrick

Use when working with C#, F#, .NET libraries, ASP.NET Core, Blazor, Entity Framework Core, and the broader .NET ecosystem. USE FOR: .NET language features, choosing libraries and frameworks, project structure, package selection, architecture decisions DO NOT USE FOR: specific library configuration details (use the sub-skills: web, data, testing, eventing, cloud, etc.)

API Dev 10 3mo ago
vanman2024

supabase-clerk-sync

by vanman2024

Clerk and Supabase integration patterns for user sync, JWT authentication, and RLS policies. Use when integrating Clerk authentication with Supabase, syncing user data between platforms, configuring RLS with Clerk JWT tokens, setting up webhooks for user events, implementing secure database access with Clerk identity, or when user mentions Clerk Supabase sync, user synchronization, JWT RLS, authentication webhooks, or database user management.

Auth 10 6mo ago
vanman2024

async-sqlalchemy-patterns

by vanman2024

Async SQLAlchemy 2.0+ database patterns for FastAPI including session management, connection pooling, Alembic migrations, relationship loading strategies, and query optimization. Use when implementing database models, configuring async sessions, setting up migrations, optimizing queries, managing relationships, or when user mentions SQLAlchemy, async database, ORM, Alembic, database performance, or connection pooling.

Auth 10 7mo ago
levy-n

rag-retrieval

by levy-n

Implements RAG (Retrieval-Augmented Generation) pipelines. Covers embedding APIs (OpenAI, Gemini, Sentence-Transformers), vector stores (FAISS, ChromaDB, Pinecone), RAG variants (Query Rewrite, Conversational, Multi-hop), and evaluation (RAGAS, Faithfulness). Use when building knowledge bases, semantic search, chatbots with documents, or when user mentions 'RAG', 'embeddings', 'vector store', 'FAISS', 'ChromaDB', 'similarity search', 'retrieval', 'chunking', 'hallucination reduction', 'semantic search', or 'knowledge base'.

Database 10 4mo ago
vanman2024

mem0-fastapi-integration

by vanman2024

Memory layer integration patterns for FastAPI with Mem0 including client setup, memory service patterns, user tracking, conversation persistence, and background task integration. Use when implementing AI memory, adding Mem0 to FastAPI, building chat with memory, or when user mentions Mem0, conversation history, user context, or memory layer.

Database 10 7mo ago