flarghi/redshift-commander repository overview

⁠Redshift Commander

A single-container full-stack webapp for managing Amazon Redshift database permissions, users, groups, and roles. This tool provides a comprehensive visual interface for Redshift privilege management.

⁠Key Features

• Identity Management: Create and manage users, groups, and roles
• Comprehensive Privilege Operations: Support for all 5 types of Redshift grants/revokes:
  • Table/View privileges (SELECT, INSERT, UPDATE, DELETE, DROP, REFERENCES)
  • Default privileges (schema-level defaults)
  • Schema privileges (USAGE, CREATE)
  • Database privileges (CONNECT, CREATE, TEMP)
  • Role assignments (GRANT/REVOKE roles)
• Interactive Interface: Single-page application with dedicated sections for actions, identities, objects, and privilege preview
• Smart Object Browser: Expandable schema tree with lazy-loading tables and views
• Live Current Privileges: See current permissions for selected identities and objects
• SQL Preview & Execution: Review generated GRANT/REVOKE statements before execution
• Transaction Safety: All operations wrapped in transactions with rollback support
• Performance Optimized: Handles large clusters with thousands of objects efficiently

⁠Architecture

• Frontend: React + TypeScript + Chakra UI with Zustand state management
• Backend: Node.js + Express + TypeScript
• Database: Amazon Redshift via pg library as target, no local db
• Deployment: Single container serving both frontend and API

⁠Quick Start

⁠Using Docker (Recommended)

docker pull flarghi/redshift-commander
docker run -p 3000:3000 flarghi/redshift-commander

# Access the application
open http://localhost:3000