flowstate-dojo-platform-epicdm-platform-db

Use this skill when a task touches packages/shared/platform-db, imports @epicdm/platform-db, or needs to teach humans/agents how this package works.

Package identity:

• Package: @epicdm/platform-db
• Repository: flowstate-platform
• Version authority: package.json (0.1.0)
• Dojo course: flowstate-dojo-platform-epicdm-platform-db

How to use the package:

• Purpose: Shared D1 schema and queries for FlowState platform workers
• Start with package-local docs when present.
• Verify details against source and tests before changing behavior.
• Use the Dojo course lessons as the teaching path: setup, mental model, core workflow, integration, feature labs, maintenance.

Public surfaces discovered:

• CREDITS_PER_USDC
• usdcToCredits
• creditsToUsdc
• CreditRate
• lookupRate
• prorateStorage
• ID_PREFIXES
• EntityType
• generateId
• getDb
• PlatformDatabase
• UsageAggregationOpts
• PurchaseOpts
• findBucketByTenantId
• findActiveRates
• findExpiredTopUpRequests
• findUsageAggregations
• countUsageAggregations
• findPurchasesByTenantId
• countPurchasesByTenantId
• findPendingTopUpRequest
• UsageSummary
• findUsageSummary
• createTopUpRequest
• expireTopUpRequests
• insertNotification
• updateNotifiedThresholds
• resetNotifiedThresholds
• findOrphanedJobs
• updateJobStatus

Composable feature skilllets:

• AGGREGATION_PERIOD_TYPES: use feature labs for workflow, source anchor, and regression risk.
• AUTO_TOP_UP_METHODS: use feature labs for workflow, source anchor, and regression risk.
• Billing Notifications: use feature labs for workflow, source anchor, and regression risk.
• Blocked Addresses: use feature labs for workflow, source anchor, and regression risk.
• BLOCKED_ADDRESS_TYPES: use feature labs for workflow, source anchor, and regression risk.
• Count Purchases By Tenant Id: use feature labs for workflow, source anchor, and regression risk.
• Count Tenants By User Id: use feature labs for workflow, source anchor, and regression risk.
• Count Usage Aggregations: use feature labs for workflow, source anchor, and regression risk.
• Course Prices: use feature labs for workflow, source anchor, and regression risk.
• Course Purchases: use feature labs for workflow, source anchor, and regression risk.
• Create Top Up Request: use feature labs for workflow, source anchor, and regression risk.
• Credit Buckets: use feature labs for workflow, source anchor, and regression risk.
• Credit Purchases: use feature labs for workflow, source anchor, and regression risk.
• Credit Rates: use feature labs for workflow, source anchor, and regression risk.
• CREDIT_EVENT_TYPES: use feature labs for workflow, source anchor, and regression risk.
• CREDIT_PURCHASE_METHODS: use feature labs for workflow, source anchor, and regression risk.
• Credits To Usdc: use feature labs for workflow, source anchor, and regression risk.
• CREDITS_PER_USDC: use feature labs for workflow, source anchor, and regression risk.
• Expire Top Up Requests: use feature labs for workflow, source anchor, and regression risk.
• Find Active Rates: use feature labs for workflow, source anchor, and regression risk.
• Find Approaching Expiry: use feature labs for workflow, source anchor, and regression risk.
• Find Bucket By Tenant Id: use feature labs for workflow, source anchor, and regression risk.
• Find By Tx Hash: use feature labs for workflow, source anchor, and regression risk.
• Find Expired: use feature labs for workflow, source anchor, and regression risk.
• Find Expired Past Grace: use feature labs for workflow, source anchor, and regression risk.
• Find Expired Top Up Requests: use feature labs for workflow, source anchor, and regression risk.
• Find Orphaned Jobs: use feature labs for workflow, source anchor, and regression risk.
• Find Pending Top Up Request: use feature labs for workflow, source anchor, and regression risk.
• Find Purchases By Tenant Id: use feature labs for workflow, source anchor, and regression risk.
• Find Tenant By Subdomain: use feature labs for workflow, source anchor, and regression risk.
• Find Tenants By User Id: use feature labs for workflow, source anchor, and regression risk.
• Find Usage Aggregations: use feature labs for workflow, source anchor, and regression risk.
• Find Usage Summary: use feature labs for workflow, source anchor, and regression risk.
• Generate Id: use feature labs for workflow, source anchor, and regression risk.
• Get All Wallets: use feature labs for workflow, source anchor, and regression risk.
• Get Db: use feature labs for workflow, source anchor, and regression risk.
• Get Hot Wallet: use feature labs for workflow, source anchor, and regression risk.
• ID_PREFIXES: use feature labs for workflow, source anchor, and regression risk.
• Insert Notification: use feature labs for workflow, source anchor, and regression risk.
• JOB_STATUSES: use feature labs for workflow, source anchor, and regression risk.
• 37 additional feature skilllets are listed in dojo-manifest.json and agent-skillset.md.

Agent operating rules:

• Treat package.json as the Dojo version authority.
• Do not turn feature inventory into user-facing lessons without workflow context.
• Update this Dojo package when package behavior, docs, examples, or feature inventory changes.
• Verify downstream packages when package use and connection metadata shows inbound dependencies or references.
• Never mark publish status passed without successful cloud publish and catalog lookup.

Use this Dojo skill with package human docs, package-local feature inventory, agent-skillset.md, and the generated course.json in this folder. Keep this manifest version aligned with package.json.