Databases

SQL, NoSQL, schema design, migrations, ORMs, and database operations

skills in category: 4,315
pages available: 180

Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.

Open in full browser

Browse databases skills

Showing 3,601–3,624 of 4,315 skills

Data WranglerATransform and export data using DuckDB SQL. Read CSV/Parquet/JSON/Excel/databases, apply SQL transformations (joins, aggregations, PIVOT/UNPIVOT, sampling), and optionally write results to files. Use when the user wants to: (1) Clean, filter, or transform data, (2) Join multiple data sources, (3) Convert between formats (CSV→Parquet, etc.), (4) Create partitioned datasets, (5) Sample large datasets, (6) Export query results. Prefer this over in-context reasoning for datasets with thousands of...databasesgoshellVotes: 0GitHub stars: 3
Sqlalchemy Alembic Expert Best Practices Code ReviewASQLAlchemy ORM and Alembic migration best practices for building safe, performant database schemas. This skill should be used when writing, reviewing, or refactoring SQLAlchemy models, Alembic migrations, or database query patterns. Triggers on tasks involving SQLAlchemy ORM, Alembic migrations, database schema changes, or query optimization.databasesgosqlVotes: 0GitHub stars: 8
Postgresql Expert Best Practices Code ReviewAPostgreSQL database design, migration, and performance optimization best practices. This skill should be used when writing, reviewing, or refactoring database schemas, migrations, or query patterns. Triggers on tasks involving PostgreSQL databases, schema design, migration optimization, or data modeling.databasesgosqlVotes: 0GitHub stars: 8
Triple MemoryAComplete memory system combining LanceDB auto-recall, Git-Notes structured memory, and file-based workspace search. Use when setting up comprehensive agent memory, when you need persistent context across sessions, or when managing decisions/preferences/tasks with multiple memory backends working together.databasespythonbashVotes: 0GitHub stars: 651
Triple Memory 2AComplete memory system combining LanceDB auto-recall, Git-Notes structured memory, and file-based workspace search. Use when setting up comprehensive agent memory, when you need persistent context across sessions, or when managing decisions/preferences/tasks with multiple memory backends working together.databasespythonbashVotes: 0GitHub stars: 651
SupabaseAConnect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.databasesbashsqlVotes: 0GitHub stars: 651
Sql GenAGenerate SQL queries from natural languagedatabasesbashsqlVotes: 0GitHub stars: 651
Schema GenAGenerate database schemas from descriptionsdatabasesgobashVotes: 0GitHub stars: 651
PlaidAplaid-cli a cli for interacting with the plaid finance platform. link accounts from various institutions, query balances, and transactions by date range listing accounts/balances.databasesgobashVotes: 0GitHub stars: 651
Lancedb MemoryA""" LanceDB integration for long-term memory management. Provides vector search and semantic memory capabilities. """ import os import json import lancedb from datetime import datetime from typing import List, Dict, Any, Optional from pathlib import Path class LanceMemoryDB: """LanceDB wrapper for long-term memory storage and retrieval.""" def __init__(self, db_path: str = "/Users/prerak/clawd/memory/lancedb"): self.db_path = Path(db_path) self.db_path.mkdir(parents=True, exist_ok=True) self....databasespythongoVotes: 0GitHub stars: 651
Duckdb EnADuckDB CLI specialist for SQL analysis, data processing and file conversion. Use for SQL queries, CSV/Parquet/JSON analysis, database queries, or data conversion. Triggers on "duckdb", "sql", "query", "data analysis", "parquet", "convert data".databasesgobashVotes: 0GitHub stars: 651
Better NotionBFull CRUD for Notion pages, databases, and blocks. Create, read, update, delete, search, and query.databasesbashapiVotes: 0GitHub stars: 651
Apple MailAApple Mail.app integration for macOS. Read inbox, search emails, send emails, reply, and manage messages with fast direct access (no enumeration).databasesgobashVotes: 0GitHub stars: 651
Apple Mail SearchAFast & safe Apple Mail search with body content support.databasesbashsqlVotes: 0GitHub stars: 651
Apple Mail Search 2AFast Apple Mail search via SQLite on macOS. Search emails by subject, sender, date, attachments - results in ~50ms vs 8+ minutes with AppleScript. Use when asked to find, search, or list emails.databasesbashsqlVotes: 0GitHub stars: 651
Moai Lang SqlASQL best practices with pgTAP, sqlfluff 3.2, query optimization, and migration management.databasesrustbashVotes: 0GitHub stars: 4
Moai Baas Supabase ExtAEnterprise Supabase PostgreSQL Platform with AI-powered open-source BaaS architecture, Context7 integration, and intelligent PostgreSQL orchestration for scalable modern applicationsdatabasestypescriptpythonVotes: 0GitHub stars: 4
Moai Baas Neon ExtAEnterprise Neon Serverless PostgreSQL Platform with AI-powered database architecture, Context7 integration, and intelligent branching orchestration for scalable modern applicationsdatabasestypescriptpythonVotes: 0GitHub stars: 4
Moai Baas Convex ExtAEnterprise Convex Real-Time Backend with AI-powered reactive database architecture, Context7 integration, and intelligent synchronization orchestration for collaborative applicationsdatabasestypescriptpythonVotes: 0GitHub stars: 4
Moai Alfred Clone PatternAEnterprise Master-Clone pattern implementation guide for complex multi-step tasks with full project context, autonomous delegation, parallel processing, and intelligent task distribution; activates for large-scale migrations, complex refactoring, parallel exploration, architecture restructuring, and multi-file transformationsdatabasestypescriptrustVotes: 0GitHub stars: 4
Extracting Filemaker Business LogicAUse when analyzing FileMaker DDR to extract calculations, custom functions, and business logic for PostgreSQL import processes or maintenance scripts - focuses on understanding and adapting FileMaker logic rather than direct schema migrationdatabasespythonsqlVotes: 0GitHub stars: 4
Redis SpecialistARedis expert for caching, pub/sub, data structures, and distributed systems patternsUse when "redis, caching strategy, cache invalidation, pub/sub, rate limiting, distributed lock, session storage, leaderboard, message queue, upstash, redis, caching, pub-sub, session, rate-limiting, distributed-lock, upstash, elasticache, memorystore" mentioned.databasessqldatabaseVotes: 0GitHub stars: 137
PrismaAExpert in Prisma - the TypeScript ORM for type-safe database access. Covers schema design, migrations, Prisma Client queries, relations, edge deployment, and performance optimization. Essential for building reliable database layers in TypeScript applications. Use when "prisma, orm, database typescript, prisma client, prisma migrate, type-safe database, prisma, orm, database, typescript, postgresql, migrations, type-safe" mentioned.databasestypescriptsqlVotes: 0GitHub stars: 137
Postgres WizardAPostgreSQL internals specialist for query optimization, indexing, partitioning, and advanced featuresUse when "postgresql, postgres, slow query, index, explain analyze, vacuum, connection pool, pgbouncer, partitioning, replication, postgresql, postgres, database, sql, indexing, optimization, partitioning, vacuum, explain, pgvector, ml-memory" mentioned.databasessqldatabaseVotes: 0GitHub stars: 137