skills.rest
CloakingGhost
CloakingGhostCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database

Design PostgreSQL schemas with JPA entity mapping and Redis token storage.

Updated Feb 5, 2026
Search Tags:#schema design#database#postgresql#redis#jpa#refresh token
One-click install
npx skills add https://github.com/CloakingGhost/design-pattern-viz --skill database-cloakingghost
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/CloakingGhost/design-pattern-viz/tree/main/ai-system/.skills/database
Command: npx skills add https://github.com/CloakingGhost/design-pattern-viz --skill database-cloakingghost

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides clear guidelines and conventions for designing PostgreSQL schemas, mapping JPA entities, and configuring Redis for secure refresh token storage, ensuring data integrity and efficient backend operations.

Core Features & Use Cases

  • PostgreSQL Schema Design: Defines table structures, relationships, and data types based on DBML.
  • JPA Entity Mapping: Aligns database schema with backend Java Persistence API entities.
  • Redis Configuration: Specifies the pattern for storing and managing user refresh tokens.
  • Use Case: When developing a new feature that requires user authentication and data persistence, consult this Skill to ensure the database schema and token management follow established best practices.

Quick Start

Refer to the database skill's PostgreSQL schema design for the 'users' table structure.

Frequently Asked Questions about database

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

FAQPage Schema
How do I design a PostgreSQL schema with audit fields and soft delete conventions?▼

Designing a PostgreSQL schema with audit fields involves defining table structures, relationships, and data types while enforcing soft delete conventions across all entities to ensure data integrity and consistent backend operations.

What is the best way to configure Redis for storing user refresh tokens?▼

Configuring Redis for refresh token storage requires using a specific key-value pattern to manage user sessions securely, ensuring efficient token validation and revocation during the authentication process.

How do I map JPA entities to a PostgreSQL database schema?▼

Mapping JPA entities to a PostgreSQL database schema aligns Java Persistence API objects with established table definitions and relationships, ensuring backend data persistence follows best practices.

Does this database schema design guide include table relationships and data type definitions?▼

Yes, the database schema design guide includes comprehensive table structures, relationship mappings, and specific data type definitions based on DBML to structure your PostgreSQL database effectively.

When do I need to enforce soft delete conventions in my database schema?▼

You need to enforce soft delete conventions in your database schema when retaining historical records is required for audit purposes, ensuring entities maintain data integrity without permanently erasing rows.

Related Skills

Explore More Software Engineering Skills→
diego-tobalinadiego-tobalina
1

postgres-patterns

Design JPA entities, Flyway migrations, and optimized queries for PostgreSQL.

Community
Intermediate
halim-23halim-23
1

odoo-controller

Implement secure Odoo HTTP controllers with routes and authentication.

Community
Advanced
ax128ax128
56

AegisGate Agent Skill

Deploy AegisGate via Docker or local bootstrap and configure token routing.

Community
Advanced
ArieGoldkinArieGoldkin
10

database-schema-designer

Design normalized SQL and NoSQL database schemas with indexing and migration planning.

Community
Basic