4

Tables (11)

credentials

  • id — BIGSERIAL — Primary key — NOT NULL
  • mcp_id — BIGINT — NOT NULL
  • key_value — VARCHAR(500) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

imports

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → profiles.id — NOT NULL
  • target_type — import_target_type — NOT NULL
  • target_id — BIGINT — NOT NULL
  • imported_at — TIMESTAMP — NOT NULL

mcp_catalog

  • id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • key_required — BOOLEAN — NOT NULL
  • key_issue_url — VARCHAR(255)
  • metadata_json — JSON
  • created_at — TIMESTAMP — NOT NULL

processed

  • id — BIGSERIAL — Primary key — NOT NULL
  • workflow_id — BIGINT — NOT NULL
  • item_key — VARCHAR(255) — NOT NULL
  • processed_at — TIMESTAMP — NOT NULL

profiles

  • id — BIGSERIAL — Primary key — NOT NULL
  • clerk_user_id — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

run_state

  • id — BIGSERIAL — Primary key — NOT NULL
  • workflow_id — BIGINT — NOT NULL
  • run_id — VARCHAR(100) — NOT NULL
  • status — run_status — NOT NULL
  • paused_at — TIMESTAMP
  • resumed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

skill_tags

  • skill_id — BIGINT — Foreign key → skills.id — NOT NULL
  • tag_id — BIGINT — Foreign key → tags.id — NOT NULL

skills

  • id — BIGSERIAL — Primary key — NOT NULL
  • author_id — BIGINT — Foreign key → profiles.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • content_md — TEXT — NOT NULL
  • import_count — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tags

  • id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL

workflow_tags

  • workflow_id — BIGINT — Foreign key → workflows.id — NOT NULL
  • tag_id — BIGINT — Foreign key → tags.id — NOT NULL

workflows

  • id — BIGSERIAL — Primary key — NOT NULL
  • author_id — BIGINT — Foreign key → profiles.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • graph_json — JSON — NOT NULL
  • import_count — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL