Databases

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

skills in category: 4,325
pages available: 181

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,385–3,408 of 4,325 skills

DatabaseADatabase design, SQL, NoSQL, and data management patternsdatabasesjavascripttypescriptVotes: 0GitHub stars: 3
Data Migration ExpertAUse this agent when reviewing PRs that touch database migrations, data backfills, or any code that transforms production data. This agent validates ID mappings against production reality, checks for swapped values, verifies rollback safety, and ensures data integrity during schema changes. Essential for any migration that involves ID mappings, column renames, or data transformations. <example>Context: The user has a PR with database migrations that involve ID mappings. user: \"Review this PR ...databasesrustgoVotes: 0GitHub stars: 3
Data Integrity GuardianAUse this agent when you need to review database migrations, data models, or any code that manipulates persistent data. This includes checking migration safety, validating data constraints, ensuring transaction boundaries are correct, and verifying that referential integrity and privacy requirements are maintained. <example>Context: The user has just written a database migration that adds a new column and updates existing records. user: \"I've created a migration to add a status column to the ...databasesgorailsVotes: 0GitHub stars: 3
Nestjs Typeorm IntegrationAUse this skill whenever the user wants to set up, configure, or refactor TypeORM within a NestJS TypeScript project, including data sources, entities, migrations, repositories, relations, and transactional patterns.databasestypescriptsqlVotes: 0GitHub stars: 2
Defillama DataA使用 DefiLlama API/SDK 获取 TVL、stablecoins、coins 价格、yields、volumes、fees、perps、unlocks、bridges、ETFs、narratives、token liquidity、main page、DAT、meta 等数据的 CLI 技能；当需要用命令行调用 DefiLlama 数据时使用。databasesgobashVotes: 0GitHub stars: 73
Lucia AuthALucia was a TypeScript library for database-backed session authentication. Its npm package was deprecated in March 2025 and the project now ships one reference file for writing the session code yourself. Use when a project imports `lucia` or `@lucia-auth/adapter-*`, when npm prints the lucia deprecation warning, or when someone asks to "add Lucia auth", "migrate off Lucia v3", "implement sessions like Lucia", or "replace Arctic". Covers the project's current status, a hand-written session mod...databasestypescriptgoVotes: 0GitHub stars: 142
KyselyAWrite type-safe SQL with Kysely query builder. Use when a user asks to write raw SQL with TypeScript safety, build queries without an ORM, use a lightweight SQL builder, or migrate from Knex with type safety.databasestypescriptgoVotes: 0GitHub stars: 142
KnexAKnex.js is a SQL query builder for Node.js with a chainable API, schema migrations, seeds and transactions for PostgreSQL, MySQL, MariaDB, SQLite and MSSQL. Use when writing queries without a full ORM, setting up knexfile.js and migrations, running knex migrate:latest, building joins, subqueries and transactions, or typing results with TypeScript.databasestypescriptgoVotes: 0GitHub stars: 142
KeystonejsAExpert guidance for KeystoneJS, the open-source headless CMS and application platform built on Node.js, GraphQL, and Prisma. Helps developers define content schemas, build admin interfaces, implement access control, and create custom GraphQL APIs for content-driven applications.databasestypescriptgoVotes: 0GitHub stars: 142
Gdpr ComplianceAAutomate GDPR and privacy compliance for web applications. Use when someone asks to "make the app GDPR compliant", "add cookie consent", "handle data deletion requests", "audit PII", "data subject access request", or "privacy policy generator". Covers PII auditing, consent management, data subject request endpoints, retention policies, and privacy policy generation.databasesgosqlVotes: 0GitHub stars: 142
FlaskAFlask is a lightweight Python micro web framework that provides the essentials for web development without imposing structure. It uses Jinja2 templates and Werkzeug WSGI toolkit, with a rich ecosystem of extensions for databases, auth, and more.databasespythongoVotes: 0GitHub stars: 142
Database OptimizerAExpert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures.databasesgosqlVotes: 0GitHub stars: 30,495
Etl PipelineADesign and automate Extract, Transform, Load data pipelines for data integration and analyticsdatabasespythongoVotes: 0GitHub stars: 92
Db MigratorADatabase schema migration, versioning, and rollback management for SQL and NoSQL databases. Use when: (1) creating database migrations, (2) modifying table schemas, (3) adding/removing columns, (4) creating indexes, (5) data migrations, (6) rollback operations, (7) multi-environment sync, (8) seed data management. Supports PostgreSQL, MySQL, MongoDB, SQLite. Triggers: "migration", "alter table", "schema change", "database migration", "rollback migration", "knex", "prisma migrate", "flyway", "...databasesjavascriptpythonVotes: 0GitHub stars: 92
Kubernetes Database AnalystAAnalyzes data from databases in Kubernetes clusters by setting up port forwarding, executing SQL queries, and generating CSV reports.databasespythonsqlVotes: 0GitHub stars: 8
Invoice Receipt ProcessorAWhen the user needs to process invoice receipts from PDF files in a workspace and update a purchase invoice database with payment tracking. This skill automatically scans workspace directories for PDF receipts, extracts invoice data (invoice ID, supplier, amount, purchaser email, date, payment status), inserts records into database tables, sets up payment tracking with outstanding flags, identifies unpaid or partially paid invoices, and sends email notifications to relevant purchasing manager...databasesdatabaseVotes: 0GitHub stars: 8
Invoice Processor Reimbursement CalculatorAScans a workspace for invoice PDFs, extracts vendor, date, amount, and currency, fetches historical exchange rates, converts all amounts to a target currency (default CNY), calculates totals including tax, and outputs a CSV summary and a JSON grand total.databasesVotes: 0GitHub stars: 8
Geolocation Distance FilterAWhen the user needs to filter locations based on proximity to a reference point within a specified radius. This skill geocodes addresses to coordinates, calculates distances between locations, and filters results based on maximum distance thresholds. Triggers include 'within X km/miles of', 'distance from', 'near location', 'proximity filter', or when location-based filtering is required for job applications, real estate, or service area analysis.databasesgogitVotes: 0GitHub stars: 8
Expense Database WriterAWhen the user needs to write validated expense claim data into structured databases with proper flagging for policy violations. This skill formats expense claim information into database-compatible schemas, inserts records into reimbursement tables, and sets appropriate flags (e.g., flag=1 for abnormal claims) based on validation results. Triggers include database insertion, reimbursement record creation, expense claim archiving, or when moving validated claims to permanent storage in databas...databasesgodatabaseVotes: 0GitHub stars: 8
Query WritingAFor writing and executing SQL queries - from simple single-table queries to complex multi-table JOINs and aggregationsdatabasessqlVotes: 0GitHub stars: 8
DocAPostGIS-focused SQL tips, tricks and gotchas. Use when in need of dealing with geospatial data in Postgres.databasesgosqlVotes: 0GitHub stars: 8
CommandsACreate a new OpenCode skill with AI assistance. Uses skill-creator for intelligent skill generation.databasesbashsqlVotes: 0GitHub stars: 8
Visa CheckerACheck visa requirements, transit rules, passport validity requirements, and travel document status for any destination. Use when planning international travel, checking entry requirements, verifying passport validity, or needing vaccination/insurance reminders for specific countries.databasespythongoVotes: 0GitHub stars: 71
Sales NeonANeon PostgreSQL vault/archive configuration, schema, and operational patterns for the Sales Navigator hub (HUB-SALES-NAV-20260130). Use this skill whenever querying, migrating, debugging, or making data-layer decisions in the sales-navigator repo. Trigger on: Neon, PostgreSQL, Postgres, database, schema, sales_state, sales_factfinder, sales_insurance, sales_systems, sales_quotes, column_registry, migration, connection pooling, NEON_DATABASE_URL, pipeline tracking, prospect data, meeting data,...databasestypescriptgoVotes: 0GitHub stars: 71