Everything your team needs to work with data
From connecting and viewing to editing, joining, scheduled re-runs and ready-to-send reports, in one app.
Database connections
Connect PostgreSQL, MySQL, SQL Server, Oracle, SQLite and MongoDB over TLS or an SSH tunnel, mark them read-only, and let the team use them without knowing the password.
DetailsData Explorer
Open a table, filter, sort and edit it like a spreadsheet, export to CSV, and keep the before and after of every edit in the audit log.
DetailsTable Designer
Create tables and change columns on screen, see the SQL before you confirm, and have every change recorded in the audit log.
DetailsJoin Canvas
Drag tables from different databases or Excel files onto a canvas, join, filter and group them, and see the result right away.
DetailsPipelines and schedules
Save a Join Canvas result as a table in the database you choose, or send it as a report by email, SFTP, S3 or a shared folder. Run it by hand or on a schedule, and see every run.
DetailsReport templates
Design report pages in bands, like Crystal or Jasper, with tables, sub-reports, totals, a logo and Thai fonts, and let a pipeline send them as PDF, Excel, Word or an image in the email.
DetailsTeam and audit log
Invite members with a link, give them one of 4 roles, sign in with SSO (Pro plan), and see every change with its before and after.
Details
And more
SQL Editor
Write your own query when you want, against one connection or across several. Rows depend on the plan.
CSV and Excel import
Upload a CSV or .xlsx file up to 50 MB and import it as a new table, append it to an existing one, or join it on the canvas.
API access
Dev and Pro plans can create API keys to call Ruamhub from other systems.
Bring all your databases into one place
Start free, or book a demo and we will walk through it with your own team’s data.