Databases

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

skills in category: 4,314
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 4,297–4,314 of 4,314 skills

Sql TranslationAUse this skill when adding new SQL function translations for a specific database backend.databasesgobashVotes: 0GitHub stars: 393
Sql ResearchAUse this skill when researching SQL syntax and behavior for any database backend before implementing translations or features in dbplyr.databasessqlexpressVotes: 0GitHub stars: 393
Relational Database Mcp CloudbaseAThis is the required documentation for agents operating on the CloudBase Relational Database. It lists the only four supported tools for running SQL and managing security rules. Read the full content to understand why you must NOT use standard Application SDKs and how to safely execute INSERT, UPDATE, or DELETE operations without corrupting production data.databasessqlnodeVotes: 0GitHub stars: 393
Postgresql Syntax ReferenceAUse this skill when you need to understand PostgreSQL's SQL syntax, DDL statement structure, or how PostgreSQL parses specific SQL constructs. This is essential for correctly parsing SQL files and generating valid DDL in pgschema.databasesgobashVotes: 0GitHub stars: 393
Pg Dump ReferenceAUse this skill when implementing or debugging pgschema features that involve extracting schema information from PostgreSQL databases. pg_dump is the canonical PostgreSQL schema dumping tool and serves as a reference implementation for how to query system catalogs correctly.databasesgosqlVotes: 0GitHub stars: 393
Mongodb UsageAUse the MongoDB MCP server to integrate database queries into workflows.databasesgoshellVotes: 0GitHub stars: 393
Moai Domain DatabaseADatabase specialist covering PostgreSQL, MongoDB, Redis, and advanced data patterns for modern applicationsdatabasespythongoVotes: 0GitHub stars: 393
Insforge Schema PatternsAExpert patterns for designing PostgreSQL schemas optimized for InsForge's PostgREST backend.databasesjavascriptjavaVotes: 0GitHub stars: 393
DatabasesBUnified guide for working with MongoDB (document-oriented) and PostgreSQL (relational) databases. Choose the right database for your use case and master both systems.databasesjavascriptpythonVotes: 0GitHub stars: 393
Data Model CreationAOptional advanced tool for complex data modeling. For simple table creation, use relational-database-tool directly with SQL statements.databasesgosqlVotes: 0GitHub stars: 393
Data MigrationAPlan and execute database migrations, data transformations, and system migrations safely with rollback strategies and data integrity validation. Use when migrating databases, transforming data schemas, moving between database systems, implementing versioned migrations, handling data transformations, ensuring data integrity, or planning zero-downtime migrations.databasessqltestingVotes: 0GitHub stars: 393
Cloudbase Document Database Web SdkAThis skill provides guidance on using the CloudBase document database Web SDK for data operations in web applications.databasesjavascriptgoVotes: 0GitHub stars: 393
Setup Timescaledb HypertablesAInstructions for insert-heavy data patterns where data is inserted but rarely changed: - **Time-series data** (sensors, metrics, system monitoring) - **Event logs** (user events, audit trails, application logs) - **Transaction records** (orders, payments, financial transactions) - **Sequential data** (records with auto-incrementing IDs and timestamps) - **Append-only datasets** (immutable records, historical data)databasesgosqlVotes: 0GitHub stars: 1,847
Migrate Postgres Tables To HypertablesAMigrate identified PostgreSQL tables to TimescaleDB hypertables with optimal configuration, migration planning and validation. **Prerequisites**: Tables already identified as hypertable candidates (use companion "find-hypertable-candidates" skill if needed).databasesgosqlVotes: 0GitHub stars: 1,847
Find Hypertable CandidatesAIdentify tables that would benefit from TimescaleDB hypertable conversion. After identification, use the companion "migrate-postgres-tables-to-hypertables" skill for configuration and migration.databasespythongoVotes: 0GitHub stars: 1,847
Design Postgres TablesAComprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced featuresdatabasesgosqlVotes: 0GitHub stars: 1,847
Backend Models StandardsA**Core Rule:** Models define data structure and integrity. Keep them focused on data representation, not business logic.databasespythongoVotes: 0GitHub stars: 2,080
Backend Migration StandardsAApply these rules when creating or modifying database migrations. Migrations are permanent records of schema evolution and must be treated with extreme care.databasesjavascriptpythonVotes: 0GitHub stars: 2,080