Open-source manufacturing ERP, MES and QMS. Quoting, MRP, inventory, shop floor, quality and lot/serial traceability on one Postgres schema, with a REST API and MCP server. Self-host or use Carbon Cloud.
TypeScript ai-agentsbill-of-materialserpinventory-managementleanmanufacturingmanufacturing-execution-systemmcp-servermesmrpopen-source-erppostgresqlproduction-planningqmsquality-management-systemreact-routerself-hostedsupabasetraceabilitytypescript
// SPDX-License-Identifier: AGPL-3.0-only
// Carbon (github.com/crbnos/carbon). Modified or adapted versions of this file,
// including ports, remain AGPLv3; serving them over a network requires releasing their source.
import { $ } from "execa";
import { client } from "./client";
import { fetchFlagsDocument } from "./flags";
export type Workspace = {
id: number;
name: string;
slug: string;
active: boolean;
seeded: boolean;
// AWS Configuration
aws: boolean;
aws_account_id: string | null;
aws_region: string | null;
// Assembler (CAD -> GLB) Configuration — deployed separately by
// ci/src/assembler.ts, gated on `assembler`.
assembler: boolean;
assembler_api_key: string | null;
cert_arn_assembler: string | null;
assembler_domain: string | null;
// Domain Configuration
domain_name: string | null;
cert_arn_erp: string | null;
cert_arn_mes: string | null;
// Database Configuration
connection_string: string | null;
database_url: string | null;
database_connection_pooler_url: string | null;
project_id: string | null;
access_token: string | null;
anon_key: string | null;
database_password: string | null;
jwt_secret: string | null;
service_role_key: string | null;
// App Configuration
auth_providers: string | null;
carbon_edition: string | null;
cloudflare_turnstile_secret_key: string | null;
cloudflare_turnstile_site_key: string | null;
controlled_environment: string | null;
exchange_rates_api_key: string | null;
google_client_id: string | null;
google_client_secret: string | null;
google_oauth_redirect_url: string | null;
google_places_api_key: string | null;
inngest_base_url: string | null;
inngest_event_key: string | null;
inngest_signing_key: string | null;
jira_client_id: string | null;
jira_client_secret: string | null;
jira_oauth_redirect_url: string | null;
jira_state_secret: string | null;
onshape_client_id: string | null;
onshape_client_secret: string | null;
onshape_oauth_redirect_url: string | null;
onshape_v2_client_id: string | null;
onshape_v2_client_secret: string | null;
onshape_v2_oauth_redirect_url: string | null;
openai_api_key: string | null;
posthog_api_host: string | null;
posthog_project_public_key: string | null;
quickbooks_client_id: string | null;
quickbooks_client_secret: string | null;
quickbooks_webhook_secret: string | null;
ramp_client_id: string | null;
ramp_client_secret: string | null;
redis_url: string | null;
resend_api_key: string | null;
resend_domain: string | null;
session_secret: string | null;
slack_bot_token: string | null;
slack_client_id: string | null;
slack_client_secret: string | null;
slack_oauth_redirect_url: string | null;
slack_signing_secret: string | null;
stripe_bypass_company_ids: string | null;
stripe_secret_key: string | null;
stripe_webhook_secret: string | null;
stripe_connect_webhook_secret: string | null;
url_erp: string | null;
url_mes: string | null;
xero_client_id: string | null;
xero_client_secret: string | null;
xero_webhook_secret: string | null;
// Feature flags, fetched at deploy time (fetchFlagsDocument).
flags_endpoint: string | null;
flags_token: string | null;
};
async function deploy(): Promise<void> {
console.log("✅ 🌱 Starting deployment");
const imageTag = process.env.IMAGE_TAG;
if (!imageTag) {
console.error("🔴 🍳 Missing IMAGE_TAG environment variable");
process.exit(1);
}
console.log(`✅ 🏷️ Using image tag: ${imageTag}`);
const { data: workspaces, error } = await client
.from("workspaces")
.select("*");
if (error) {
console.error("🔴 🍳 Failed to fetch workspaces", error);
process.exit(1);
}
let hasErrors = false;
console.log("✅ 🛩️ Successfully retreived workspaces");
for await (const workspace of workspaces as Workspace[]) {
try {
console.log(`✅ 🥚 Migrating ${workspace.id}`);
const {
anon_key,
assembler_api_key,
assembler_domain,
auth_providers,
aws_account_id,
aws_region,
aws,
carbon_edition,
cert_arn_erp,
cert_arn_mes,
cloudflare_turnstile_secret_key,
cloudflare_turnstile_site_key,
controlled_environment,
database_connection_pooler_url,
database_password,
database_url,
domain_name,
exchange_rates_api_key,
flags_endpoint,
flags_token,
google_client_id,
google_client_secret,
google_oauth_redirect_url,
google_places_api_key,
inngest_base_url,
inngest_event_key,
inngest_signing_key,
jira_client_id,
jira_client_secret,
jira_oauth_redirect_url,
jira_state_secret,
jwt_secret,
onshape_client_id,
onshape_client_secret,
onshape_oauth_redirect_url,
onshape_v2_client_id,
onshape_v2_client_secret,
onshape_v2_oauth_redirect_url,
openai_api_key,
posthog_api_host,
posthog_project_public_key,
quickbooks_client_id,
quickbooks_client_secret,
quickbooks_webhook_secret,
ramp_client_id,
ramp_client_secret,
redis_url,
resend_api_key,
resend_domain,
service_role_key,
session_secret,
slack_bot_token,
slack_client_id,
slack_client_secret,
slack_oauth_redirect_url,
slack_signing_secret,
slug,
stripe_bypass_company_ids,
stripe_secret_key,
stripe_webhook_secret,
stripe_connect_webhook_secret,
url_erp,
url_mes,
xero_client_id,
xero_client_secret,
xero_webhook_secret,
} = workspace;
if (!aws) {
continue;
}
if (!aws_account_id) {
console.log(`🔴🍳 Missing AWS account id for ${workspace.id}`);
continue;
}
if (!aws_region) {
console.log(`🔴🍳 Missing AWS region for ${workspace.id}`);
continue;
}
if (!domain_name) {
console.log(`🔴🍳 Missing domain name for ${workspace.id}`);
continue;
}
if (!cert_arn_erp) {
console.log(`🔴🍳 Missing ERP domain cert ARN for ${workspace.id}`);
continue;
}
if (!cert_arn_mes) {
console.log(`🔴🍳 Missing MES domain cert ARN for ${workspace.id}`);
continue;
}
if (!database_url) {
console.log(`🔴🍳 Missing database url for ${workspace.id}`);
continue;
}
if (!database_connection_pooler_url) {
console.log(
`🔴🍳 Missing database connection pooler url for ${workspace.id}`
);
continue;
}
if (!database_password) {
console.log(`🔴🍳 Missing database password for ${workspace.id}`);
continue;
}
if (!anon_key) {
console.log(`🔴🍳 Missing anon key for ${workspace.id}`);
continue;
}
if (!service_role_key) {
console.log(`🔴🍳 Missing service role key for ${workspace.id}`);
continue;
}
if (!resend_api_key) {
console.log(`🔴🍳 Missing Resend API key for ${workspace.id}`);
continue;
}
if (!session_secret) {
console.log(`🔴🍳 Missing session secret for ${workspace.id}`);
continue;
}
if (!inngest_signing_key) {
console.log(`🔴🍳 Missing Inngest signing key for ${workspace.id}`);
continue;
}
if (!inngest_event_key) {
console.log(`🔴🍳 Missing Inngest event key for ${workspace.id}`);
continue;
}
if (!redis_url) {
console.log(`🔴🍳 Missing Redis URL for ${workspace.id}`);
continue;
}
if (!url_erp) {
console.log(`🔴🍳 Missing ERP url for ${workspace.id}`);
continue;
}
if (!url_mes) {
console.log(`🔴🍳 Missing MES url for ${workspace.id}`);
continue;
}
console.log(`✅ 🔑 Setting up environment for ${workspace.id}`);
// Normalize the assembler domain into a full URL, tolerating a value that
// already includes a scheme (avoids "https://https://...").
const assembler_service_url = assembler_domain
? /^https?:\/\//.test(assembler_domain)
? assembler_domain
: `https://${assembler_domain}`
: undefined;
// Feature flags are fixed at deploy time. A failed fetch fails this
// workspace's deploy, and the running release keeps its flags.
const carbon_flags_endpoint = flags_endpoint
? await fetchFlagsDocument(flags_endpoint, flags_token, imageTag)
: undefined;
const $$ = $({
// @ts-ignore
env: {
AWS_ACCOUNT_ID: aws_account_id,
AWS_REGION: aws_region,
IMAGE_TAG: imageTag,
ASSEMBLER_SERVICE_API_KEY: assembler_api_key ?? undefined,
ASSEMBLER_SERVICE_URL: assembler_service_url,
AUTH_PROVIDERS: auth_providers ?? undefined,
CARBON_EDITION: carbon_edition ?? "enterprise",
CARBON_FLAGS_ENDPOINT: carbon_flags_endpoint,
CERT_ARN_ERP: cert_arn_erp,
CERT_ARN_MES: cert_arn_mes,
CLOUDFLARE_TURNSTILE_SECRET_KEY:
cloudflare_turnstile_secret_key ?? undefined,
CLOUDFLARE_TURNSTILE_SITE_KEY:
cloudflare_turnstile_site_key ?? undefined,
CONTROLLED_ENVIRONMENT: controlled_environment ?? undefined,
DOMAIN: domain_name,
EXCHANGE_RATES_API_KEY: exchange_rates_api_key ?? undefined,
GOOGLE_CLIENT_ID: google_client_id ?? undefined,
GOOGLE_CLIENT_SECRET: google_client_secret ?? undefined,
GOOGLE_OAUTH_REDIRECT_URL: google_oauth_redirect_url ?? undefined,
GOOGLE_PLACES_API_KEY: google_places_api_key ?? undefined,
INNGEST_BASE_URL: inngest_base_url ?? undefined,
INNGEST_EVENT_KEY: inngest_event_key,
INNGEST_SIGNING_KEY: inngest_signing_key,
JIRA_CLIENT_ID: jira_client_id ?? undefined,
JIRA_CLIENT_SECRET: jira_client_secret ?? undefined,
JIRA_OAUTH_REDIRECT_URL: jira_oauth_redirect_url ?? undefined,
JIRA_STATE_SECRET: jira_state_secret ?? undefined,
ONSHAPE_CLIENT_ID: onshape_client_id ?? undefined,
ONSHAPE_CLIENT_SECRET: onshape_client_secret ?? undefined,
ONSHAPE_OAUTH_REDIRECT_URL: onshape_oauth_redirect_url ?? undefined,
ONSHAPE_V2_CLIENT_ID: onshape_v2_client_id ?? undefined,
ONSHAPE_V2_CLIENT_SECRET: onshape_v2_client_secret ?? undefined,
ONSHAPE_V2_OAUTH_REDIRECT_URL:
onshape_v2_oauth_redirect_url ?? undefined,
OPENAI_API_KEY: openai_api_key,
POSTHOG_API_HOST: posthog_api_host ?? undefined,
POSTHOG_PROJECT_PUBLIC_KEY: posthog_project_public_key ?? undefined,
QUICKBOOKS_CLIENT_ID: quickbooks_client_id ?? undefined,
QUICKBOOKS_CLIENT_SECRET: quickbooks_client_secret ?? undefined,
QUICKBOOKS_WEBHOOK_SECRET: quickbooks_webhook_secret ?? undefined,
RAMP_CLIENT_ID: ramp_client_id ?? undefined,
RAMP_CLIENT_SECRET: ramp_client_secret ?? undefined,
REDIS_URL: redis_url ?? undefined,
RESEND_API_KEY: resend_api_key,
RESEND_DOMAIN: resend_domain ?? "carbon.ms",
SESSION_SECRET: session_secret,
SLACK_BOT_TOKEN: slack_bot_token ?? undefined,
SLACK_CLIENT_ID: slack_client_id ?? undefined,
SLACK_CLIENT_SECRET: slack_client_secret ?? undefined,
SLACK_OAUTH_REDIRECT_URL: slack_oauth_redirect_url ?? undefined,
SLACK_SIGNING_SECRET: slack_signing_secret ?? undefined,
STRIPE_BYPASS_COMPANY_IDS: stripe_bypass_company_ids ?? undefined,
STRIPE_SECRET_KEY: stripe_secret_key ?? undefined,
STRIPE_WEBHOOK_SECRET: stripe_webhook_secret ?? undefined,
STRIPE_CONNECT_WEBHOOK_SECRET:
stripe_connect_webhook_secret ?? undefined,
SUPABASE_ANON_KEY: anon_key,
SUPABASE_DB_URL: database_connection_pooler_url,
SUPABASE_JWT_SECRET: jwt_secret ?? undefined,
SUPABASE_SERVICE_ROLE_KEY: service_role_key,
SUPABASE_URL: database_url,
URL_ERP: url_erp,
URL_MES: url_mes,
VERCEL_ENV: "production",
XERO_CLIENT_ID: xero_client_id ?? undefined,
XERO_CLIENT_SECRET: xero_client_secret ?? undefined,
XERO_WEBHOOK_SECRET: xero_webhook_secret ?? undefined,
},
// Run SST from the repository root where sst.config.ts is located
cwd: "..",
stdio: "inherit",
});
console.log(`🚀 🐓 Deploying apps for ${workspace.id} with SST`);
await $$`npx --yes [email protected] deploy --stage prod`;
console.log(`✅ 🍗 Successfully deployed ${workspace.id}`);
} catch (error) {
console.error(`🔴 🍳 Failed to deploy ${workspace.id}`, error);
hasErrors = true;
}
}
if (hasErrors) {
console.error("🔴 Deployment completed with errors");
process.exit(1);
}
console.log("✅ All deployments completed successfully");
}
deploy().catch((error) => {
console.error("🔴 Unexpected error during deployment", error);
process.exit(1);
});