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

Ready to run

npx skills add https://github.com/CloakingGhost/design-pattern-viz --skill database-cloakingghost

💬 Prompt for ChatGPT / Claude Chat▼

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.