Molecule.dev

← All templates

Database Admin

Developer Tools · React + Node (Express) · 21 @molecule/* packages

pgAdmin-like database manager with schema browser, query runner, and data visualization — with built-in Stripe-backed subscription tiers

Open in Molecule

What is inside

  • auth
  • search
  • keyboard-shortcuts
  • subscriptions

Screens (14)

  • Login /login
  • Signup /signup
  • ForgotPassword /forgot-password
  • ResetPassword /reset-password
  • Connections /connections (signed in)
  • QueryEditor /query/:connectionId (signed in)
  • TableBrowser /table/:connectionId/:table (signed in)
  • SchemaExplorer /schema/:connectionId (signed in)
  • QueryHistory /history (signed in)
  • Monitoring /monitoring (signed in)
  • Settings /settings (signed in)
  • NewConnection /connections/new (signed in)
  • EditConnection /connections/:connectionId/edit (signed in)
  • SavedQueryDetail /history/saved/:queryId (signed in)

Data model (6 tables)

  • audit_log — id, user_id, connection_id, action, target, metadata, created_at
  • connections — id, user_id, name, host, port, database_name, username, connection_string, …
  • devices — id, createdAt, updatedAt, userId, name, pushPlatform, pushSubscription, hasPushSubscription
  • payments — id, createdAt, updatedAt, userId, transactionId, productId, platformKey, data, …
  • query_history — id, user_id, connection_id, sql, status, row_count, duration_ms, error_message, …
  • saved_queries — id, user_id, connection_id, name, sql, description, created_at, updated_at

API (3 handlers)

  • connections api/src/handlers/connections.ts
  • queries api/src/handlers/queries.ts
  • schema api/src/handlers/schema.ts

Subscription tiers

free / pro / team — gated by: maxConnections, maxQueries, maxSchema, advancedFeatures, canExport, retentionDays

Built from 21 @molecule/* packages

Browse all @molecule/* packages →

Required secrets

  • DATABASE_URL PostgreSQL connection string
  • ENCRYPTION_KEY Master encryption key for stored database connection credentials

The @molecule/* packages are Apache-2.0. The app you build from this template is yours to export and self-host. Licensing