Developer Documentation

Quick Reference

All commands, URLs, and procedures in one place

🔗 Essential URLs

Platform

Production API:  https://reformer-platform.onrender.com
Health Check:    https://reformer-platform.onrender.com/health
Company Dashboard: https://dash.reformer.la
Client Portal:   https://client.reformer.la
Docs Site:       https://developers.reformer.la

Infrastructure

Render Dashboard:   https://dashboard.render.com
Supabase Dashboard: https://supabase.com/dashboard
GitHub Repo:        https://github.com/reformer-git/reformer-platform

Integration Dashboards

Memberstack:    https://memberstack.com/dashboard
Webflow:        https://webflow.com/dashboard
Close CRM:      https://app.close.com
Dropbox:        https://dropbox.com/home
Pirsch:         https://pirsch.io
ClickUp:        https://app.clickup.com
Slack:          https://slack.com/workspace

🚀 Common Commands

Health Checks

# Check if platform is running
curl https://reformer-platform.onrender.com/health

# Check database connection
psql $DATABASE_URL -c "SELECT NOW();"

Development

# Install dependencies
npm install

# Run local development server
npm run dev

# Build for production
npm run build

📊 Database Quick Queries

Accounts

-- List all accounts
SELECT id, business_name, created_at FROM accounts;

-- Find account by name
SELECT * FROM accounts WHERE business_name ILIKE '%company%';

-- Count accounts
SELECT COUNT(*) FROM accounts;

Members

-- Recent members
SELECT email, plan_id, subscription_status, created_at 
FROM members 
ORDER BY created_at DESC 
LIMIT 20;

-- Active subscriptions
SELECT COUNT(*) 
FROM members 
WHERE subscription_status = 'active';

Integrations

-- View all integrations
SELECT 
  a.business_name, 
  i.service, 
  i.active 
FROM integrations i
JOIN accounts a ON i.account_id = a.id;

-- Active integrations by service
SELECT service, COUNT(*) 
FROM integrations 
WHERE active = true 
GROUP BY service;

🚨 Emergency Procedures

Platform Down

# 1. Check status
curl https://reformer-platform.onrender.com/health

# 2. View logs in Render Dashboard

# 3. Restart service
# Render Dashboard → Manual Deploy → Redeploy

Integration Failing

# 1. Check environment variables
# Render Dashboard → Environment

# 2. Test integration API key
# See integration-specific tests below

# 3. Review logs
# Render Dashboard → Search for integration name

📝 Environment Variables

Required

DATABASE_URL=postgresql://user:pass@host:5432/db
MEMBERSTACK_API_KEY=mem_xxx
CLOSE_API_KEY=api_xxx
DROPBOX_ACCESS_TOKEN=sl.xxx
CLICKUP_API_KEY=pk_xxx
SLACK_WEBHOOK_URL=https://hooks.slack.com/services/xxx

Where to Set

  1. Render: Dashboard → Service → Environment
  2. Local: .env file (never commit!)

📚 Related Documentation