Phase 1 DB: Connecting…
1
Submitter
2
Insured
3
Property
4
Coverage
5
Documents
6
Review
7
Submit
🏢
Submitter Information
Broker, MGA, or direct customer details → bronze_brokers
Organization Details
Organization name is required
Format: AAA-ST-0000 (letters-state-4digits)
Valid email required
Select state
Valid US phone required
Submission Metadata
Required
Required
Step 1 of 6
👤
Insured Information
Applicant PII → bronze_insureds (SSN stored as SHA-256 hash)
🔒 SSN is hashed client-side using SHA-256. The raw SSN never leaves the browser or gets stored in the database.
Personal Identity
Required
Required
Must be 18+ years old
Enter full SSN (###-##-####)
Valid email required
Valid US phone required
Mailing Address
Required
Required
Required
5 or 9-digit ZIP
Step 2 of 6
🏠
Property Information
Risk location details → bronze_properties
📍 If property address differs from mailing address, enter it below.
Risk Location Address
Required
Required
Required
5 or 9-digit ZIP
Physical Characteristics
Required
Required
1800–present
100–50,000 sq ft
Construction Details
Required
Required
Must be ≥ year built
Liability Indicators
Step 3 of 6
🛡️
Coverage Request
Coverage type and limits → bronze_submissions
Coverage Type
HO-3
Special Form
Most common homeowners
HO-4
Renters
Contents & liability only
HO-5
Comprehensive
Open perils on all
HO-6
Condo Owner
Walls-in condo coverage
DP-1
Dwelling Basic
Named perils only
DP-3
Dwelling Special
Landlord open perils
BOP
Business Owners
Property + liability
CPP
Comm. Package
Multi-line commercial
FARM
Farm & Ranch
Dwelling + equipment
Limits & Deductibles
$50,000–$10,000,000 ~$165/sq ft avg construction cost
Select deductible
Today–60 days out
Endorsements Requested
Notes
0/1000
Step 4 of 6
📎
Supporting Documents
Upload property inspection report, deed, or photos — validated before submission → bronze_submission_attachments
Document Upload — At least one property document required
Document 1 *
📄
Click to upload or drag & drop
PDF or JPG/PNG · Max 10MB
Document 2 (optional)
📄
Click to upload or drag & drop
PDF or JPG/PNG · Max 10MB
✓ Validation Rules Applied: PDF files are checked for property-related keywords (address, inspection, property, coverage, insured, roof, construction). JPG/PNG files are verified as valid images. Generic invoices or unrelated documents are rejected.
Step 5 of 6
📋
Review & Confirm
Verify all fields before Bronze layer commit
Generated JSON Payload
Submission Accepted!
Policy request committed to Bronze layer · JSON saved to disk
JSON File Path
D:\Personal\Usecase\Jsons\SUB-XXXX.json
💡 This is a browser-based app. Direct MySQL TCP connections require a backend proxy. The SQL Inserts tab generates ready-to-run statements for MySQL Workbench or CLI. The Python Connector tab provides a production-ready script for direct DB writes.
Connection Details
Pre-configured · localhost (local) or Clever Cloud (HuggingFace)
Connection Status
Live diagnostics and health check
00:00:00PolicyBridge MySQL Integration v1.0
00:00:00Target: localhost:3306 / bronze
00:00:00Click "Test Connection" to verify connectivity
Bronze Layer Tables — Write Targets
All tables that receive data on each submission
SchemaTableWrite TriggerKey FieldsStatus
bronzebronze_brokersEvery new brokerbroker_code, broker_name, contact_email● Pending
bronzebronze_insuredsEvery submissionfull_name, dob, ssn_hash, email, phone● Pending
bronzebronze_propertiesEvery submissioninsured_id, street, city, state_code, zip● Pending
bronzebronze_submissionsEvery submissionsubmission_id, broker_id, insured_id, property_id● Pending
bronzebronze_submission_attachmentsStatic S3 URIs (Phase 1)submission_id, attachment_type, s3_uri● Pending
bronzebronze_pipeline_agent_logOn submissionsubmission_id, agent_code, status=QUEUED● Pending
⚠ These statements reflect the most recently submitted form data. Submit a form on the Submission tab first.
MySQL INSERT Statements
-- Submit a form to generate INSERT statements
Event Log
--:--:--PolicyBridge v1.0 started · Phase 1
✅ This script loads submission JSON into all 6 bronze tables in the correct FK order. Place in your project and run: python bronze_loader.py SUB-2025-XXXXX.json
bronze_loader.py
Connectors Hub
Integrate PolicyBridge with any data source — databases, APIs, file systems, streaming platforms, and cloud services
24
Available Connectors
1
Connected
23
Available to Connect
AI Agent Pipeline
Phase 1: Bronze layer population · Phase 2: Agent orchestration via AWS Step Functions
Phase 1
Bronze Population (Active)
Phase 2
Agent Orchestration (Upcoming)
Phase 3
Gold Layer Analytics (Future)
base_agent.py — Agent Framework Scaffold
PolicyBridge v1.0 | Ready | localhost:3306 · bronze