Databases

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

skills in category: 4,708
pages available: 197

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,681–4,704 of 4,708 skills

Database OptimizerAOptimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution.databasessqlgitVotes: 0GitHub stars: 11,720
Using Graph DatabasesAGraph database implementation for relationship-heavy data models. Use when building social networks, recommendation engines, knowledge graphs, or fraud detection. Covers Neo4j (primary), ArangoDB, Amazon Neptune, Cypher query patterns, and graph data modeling.databasestypescriptpythonVotes: 0GitHub stars: 517
Spring Data Neo4jAProvides Spring Data Neo4j integration patterns for Spring Boot applications. Use when you need to work with a graph database, Neo4j nodes and relationships, Cypher queries, or Spring Data Neo4j. Creates node entities with @Node annotation, defines relationships with @Relationship, writes Cypher queries using @Query, configures imperative and reactive Neo4j repositories, implements graph traversal patterns, and sets up testing with embedded databases.databasesgojavaVotes: 0GitHub stars: 345
Spring Data JpaAProvides patterns to implement persistence layers with Spring Data JPA. Use when creating repositories, configuring entity relationships, writing queries (derived and `@Query`), setting up pagination, database auditing, transactions, UUID primary keys, multiple databases, and database indexing.databasesgojavaVotes: 0GitHub stars: 345
Weaviate Data IngestionAThis skill helps you upload data to your **local Weaviate collections** efficiently, handling everything from single objects to large batch imports.databasespythongoVotes: 0GitHub stars: 39
Weaviate ConnectionBThis skill helps you connect to a **local Weaviate database** instance running in Docker and verify the connection is healthy.databasespythonbashVotes: 0GitHub stars: 39
Weaviate Collection ManagerAThis skill helps you manage Weaviate collections on your **local Weaviate instance** - creating new ones, viewing existing schemas, and managing collection configurations.databasespythongoVotes: 0GitHub stars: 39
Wheels Migration GeneratorAGenerate database-agnostic Wheels migrations for creating tables, altering schemas, and managing database changes. Use when creating or modifying database schema, adding tables, columns, indexes, or foreign keys. Prevents database-specific SQL and ensures cross-database compatibility.databasesbashsqlVotes: 0GitHub stars: 393
Validate With DatabaseAUse this skill to connect to the test PostgreSQL database, validate assumptions about schema behavior, and cross-validate between pg_dump and pgschema implementations.databasesgobashVotes: 0GitHub stars: 393
SqlAYou are tasked with running SQL queries against the WordPress development database.databasesphpbashVotes: 0GitHub stars: 393
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