database

Design schemas, write SQL queries, and manage PostgreSQL migrations.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/the-Lobbi/Devopspipelineuidesign --skill database-the-lobbi
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/the-Lobbi/Devopspipelineuidesign/tree/main/.claude/skills/database
Command: npx skills add https://github.com/the-Lobbi/Devopspipelineuidesign --skill database-the-lobbi

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides comprehensive capabilities for database design, SQL query writing, migration management, and performance optimization, ensuring efficient and reliable data storage. It helps maintain data integrity and application responsiveness.

Core Features & Use Cases

  • Schema Design: Create tables, indexes, and define relationships with foreign keys for robust data models.
  • SQL Querying: Write complex CRUD operations, joins, and window functions to retrieve and manipulate data effectively.
  • Migrations: Manage database schema changes over time, ensuring smooth updates and version control for your database.
  • Use Case: Optimize a slow SQL query that retrieves agents and their associated tasks by analyzing its execution plan and suggesting appropriate indexes, drastically improving query performance.

Quick Start

Use the database skill to create a new PostgreSQL table named 'agents' with columns for 'id' (UUID primary key), 'name' (VARCHAR), and 'type' (VARCHAR).