Mahalaxmi - Database - Sahyogi Docs

Overview

MySQL 8 managed via Drizzle ORM. Schema is defined in shared/schema.ts — this is the single source of truth for all tables and types.

Local database (Docker)

# Start
docker-compose up mysql -d

# Connect via CLI
docker-compose exec mysql mysql -u dbuser -psin90is1 sahyogi

# Stop (keeps data)
docker-compose down

# Nuke everything (DELETES ALL DATA)
docker-compose down -v

Local credentials:

Host: localhost:3306
Database: sahyogi
User: dbuser
Password: sin90is1

Production database

Hosted on a managed MySQL instance (PlanetScale or equivalent — confirm with team lead for exact host). Connect with DATABASE_SSL=true.

Ask the team lead for prod DB credentials. Never commit credentials to git.

Migration commands

# Push schema changes directly to DB (dev — no migration files)
npm run db:push

# Generate SQL migration files
npm run db:migrate

# Seed the database with initial data
npm run db:seed

# Specific migration scripts
npm run db:setup-subscriptions
npm run db:add-user-fields
npm run db:create-access-control
npm run db:seed-access-control
npm run db:add-stripe-price-id

Drizzle config: drizzle.config.ts — outputs migrations to ./db/migrations/, reads schema from ./shared/schema.ts.

Key tables

Table	Purpose
`users`	User accounts, Stripe info, coin balance
`bots`	AI bot configurations
`channels`	Channel integrations (whatsapp, telegram, gmail, web, twitter, linkedin)
`gupshup_whatsapp_integrations`	Gupshup WhatsApp account config
`whatsapp_accounts`	WhatsApp Business API accounts
`conversations`	Conversation threads
`messages`	Individual messages
`whatsapp_message_info`	Delivery/read receipts
`campaigns`	Campaign templates and state
`contacts`	Customer contacts
`contact_lists`	Contact list groups
`credentials`	Encrypted API keys / OAuth tokens
`integrations`	Third-party integration records
`tools`	Bot tools/extensions
`webhooks`	User-defined webhooks
`training_files`	Uploaded PDFs for RAG
`training_urls`	URLs scraped for RAG
`plans`	Subscription plan definitions
`subscriptions`	User subscription state
`teams` / `team_members`	Team management
`roles` / `permissions`	RBAC definitions

Overview

SPN Platform

GST Processor

Heena Jewellers

Mahalaxmi Traders

Mahalaxmi - Database

Overview

Local database (Docker)

Production database

Migration commands

Key tables

​Overview

​Local database (Docker)

​Production database

​Migration commands

​Key tables

Overview

Local database (Docker)

Production database

Migration commands

Key tables