Toolverse
All skills
Backend

database-implementation

by jpicklyk

Database schema design, migrations, query optimization with SQL, Exposed ORM, Flyway. Use for database, migration, schema, sql, flyway tags. Provides migration patterns, validation commands, rollback strategies.

Installation

Pick a client and clone the repository into its skills directory.

Installation

Quick info

Author
jpicklyk
Category
Backend
Views
84
GitHub repo

About this skill

Database schema design, migrations, query optimization with SQL, Exposed ORM, Flyway. Use for database, migration, schema, sql, flyway tags. Provides migration patterns, validation commands, rollback strategies.

How to use

  1. Załaduj umiejętność w swoim agencie Claude, gdy zadanie zawiera tagi: database, migration, schema, sql, flyway, exposed, orm, query, index lub constraint. 2. Przygotuj plik migracji SQL (np. V001__create_users_table.sql) z definicją tabel, kolumn i ograniczeń zgodnie z Twoim schematem. 3. Uruchom migrację poleceniem ./gradlew flywayMigrate, aby zastosować zmiany na bazie danych. 4. Waliduj wynik migracją na czystej bazie danych (./gradlew flywayClean flywayMigrate) i sprawdzaj status (./gradlew flywayInfo). 5. Zdefiniuj modele ORM (Exposed lub JPA) mapujące encje na tabele, ustaw relacje i zachowania kaskadowe. 6. Optymalizuj zapytania — dodaj indeksy na kolumnach często przeszukiwanych, analizuj plany zapytań (EXPLAIN) i rozwiąż problemy N+1, a następnie uruchom testy (./gradlew test) aby potwierdzić, że schemat działa poprawnie i rollback (jeśli dotyczy) przywraca poprzedni stan.

Related skills

gog

by openclaw

Google Workspace CLI for Gmail, Calendar, Drive, Contacts, Sheets, and Docs.

Backend
34126

effective-go

by openshift

Apply Go best practices, idioms, and conventions from golang.org/doc/effective_go. Use when writing, reviewing, or refactoring Go code to ensure idiomatic, clean, and efficient implementations.

Backend
248296

pdf-to-markdown

by aliceisjustplaying

Convert entire PDF documents to clean, structured Markdown for full context loading. Use this skill when the user wants to extract ALL text from a PDF into context (not grep/search), when discussing or analyzing PDF content in full, when the user mentions \

Backend
355664

architecture-decision-records

by wshobson

Write and maintain Architecture Decision Records (ADRs) following best practices for technical decision documentation. Use when documenting significant technical decisions, reviewing past architectural choices, or establishing decision processes.

Backend
29130

video-downloader

by ComposioHQ

Downloads videos from YouTube and other platforms for offline viewing, editing, or archival. Handles various formats and quality options.

Backend
50173

himalaya

by openclaw

CLI to manage emails via IMAP/SMTP. Use `himalaya` to list, read, write, reply, forward, search, and organize emails from the terminal. Supports multiple accounts and message composition with MML (MIME Meta Language).

Backend
35108