database

Design database schemas, implement migrations, and optimize queries across SQL and NoSQL systems.

Updated Mar 7, 2026
One-click install
npx skills add https://github.com/involvex/llms-remote --skill database-involvex
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/involvex/llms-remote/tree/main/.agents/skills/database
Command: npx skills add https://github.com/involvex/llms-remote --skill database-involvex

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the entire database lifecycle, from initial design and implementation to optimization, migration, and ongoing operations, ensuring efficient and robust data management.

Core Features & Use Cases

  • Database Design & Architecture: Create scalable and efficient database schemas for SQL and NoSQL.
  • Implementation & Migrations: Set up ORMs, manage database migrations, and ensure data integrity.
  • Optimization & Operations: Tune query performance, manage backups, and ensure smooth database operations.
  • Data Pipelines: Develop robust data pipelines for ingestion, transformation, and quality assurance.
  • Use Case: You need to design a new PostgreSQL database schema for a user management system, implement the initial migrations using Prisma, and set up a basic data pipeline to ingest user activity logs.

Quick Start

Use the database skill to design a PostgreSQL schema for a social media application.

Frequently Asked Questions about database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a scalable PostgreSQL database schema for a new application?

To design a scalable PostgreSQL database schema, you need to structure tables, define relationships, and establish data integrity constraints. This workflow supports creating efficient schemas for SQL and NoSQL databases to ensure robust data management.

What is the best way to manage database migrations using Prisma?

The best way to manage database migrations using Prisma involves setting up the ORM, defining your schema changes, and executing migration scripts. This ensures data integrity and smooth database operations during schema evolution.

How do I optimize slow SQL queries in PostgreSQL?

To optimize slow SQL queries in PostgreSQL, you must tune query performance by analyzing execution plans and adjusting indexes. This process ensures smooth database operations and efficient data retrieval.

How do I build data pipelines for ingesting and transforming user activity logs?

Building data pipelines for user activity logs requires developing workflows for data ingestion, transformation, and quality assurance. This ensures robust data engineering and reliable analytics inputs.

Does this database workflow support NoSQL databases like MongoDB and Redis?

Yes, this database workflow supports NoSQL databases like MongoDB and Redis. It provides comprehensive capabilities for designing scalable schemas and managing operations across both SQL and NoSQL environments.

Can I use dbt and ClickHouse for data warehousing with this approach?

Yes, you can use dbt and ClickHouse for data warehousing with this approach. It supports data warehousing solutions to facilitate data transformation, pipeline development, and analytics operations.