Ingest
Bring every source into one place.
Connect PostgreSQL, MySQL, REST APIs, Google Sheets, Excel and uploaded files. Prysm keeps them in sync, keeps credentials locked away, and shows you when something stops flowing.
Sources
Six ways in.
Point Prysm at the places your data already lives. Import a table, a sheet or an endpoint, and it becomes something you can query, chart and check.
- PostgreSQL and MySQLHost, port, database and credentials. Available from Ray.
- REST APIsCustom headers with basic or bearer auth on Ray, plus OAuth2 from Beam.
- Google Sheets and ExcelSign in once. Pull on every plan, pull and push from Ray.
- Uploaded filesDrop in a file and use it as a source, or import it into a spreadsheet.
Connections
Security
Credentials stay locked.
Secrets are encrypted at rest and never shown again after you save them. Test a connection before you save it, so a typo never becomes a broken sync.
- Encrypted credential storage on every plan
- Connection sharing controls from Beam
- SSH tunnels and static egress IPs from Aurora, for private networks and allowlists
Reach host42 msAuthenticateokRead schema18 tablesPassword••••••••Sync
Fresh on your schedule.
Keep imports in sync on a schedule, or pull and push on demand. Faster plans sync more often, and Beam adds delta syncs and webhook-triggered syncs so only what changed moves.
Write-back
Live write-back, from Beam
Edit in Prysm and push changes straight back to PostgreSQL, MySQL and REST APIs. No export, no re-import.
orders_db.orders3 rowsHealth
Know when a source goes quiet.
Health monitoring shows sync status, failures and freshness for every connection. From Beam, alerts tell you when something breaks, before a dashboard shows the wrong number.
orders_dbsynced 4 min agoForecastlast sync 26 h agocrm_api401 for 3 runsFiles
A home for the files, too.
Organization file storage for the CSVs, spreadsheets and exports your team trades. From 1 GB per seat on Spark to 250 GB per seat on Supernova.