Assets to SQL transforms your Jira Assets (CMDB) data into relational SQL dumps (PostgreSQL-compatible) and CSV files for use in BI tools like eazyBI, Power BI, Tableau, or Metabase. It flattens the Assets object hierarchy into proper SQL tables with inlined reference attributes, handles multi-value fields (either flattened or as junction tables), and supports scheduled syncs with webhook delivery and a REST pull endpoint. The app runs natively on Atlassian Forge — no external databases, and data stays inside the Atlassian infrastructure.
The app requires an active license. During Marketplace review, the evaluation license provided by the review process is sufficient.
Click the "Configure" tab. You will see a 3-step progress tracker: Select Schemas → Select Object Types → Configure Attributes.
Check the box next to one or more schemas, then click "Next".
Review the listed object types and uncheck any you don't want to export. Click "Next".
Click each object type button to review its attributes. For multi-value attributes choose either "Flatten (comma-separated)" or "Junction table" mode. Click "Save Configuration".
Configure scheduled sync, webhook URL, and generate an API key for the pull endpoint. Click "Save Settings".
Complete the Configuration wizard. Go to the Export tab, select "CSV Zip" + "Download from UI", and click "Export Now". A progress bar appears; when complete, download the ZIP.
Select "SQL Dump (PostgreSQL)" and click Export Now. Use "Preview Schema" on the Configure tab to see generated DDL.
Shows last sync timestamp, trigger type, status, row count, duration, plus a table breakdown.
Table of the last 20 sync entries with expandable details.
Toggle on, set frequency, and save. Uses the same export pipeline as manual exports.
Test Webhook sends a test POST. Run an export with "Push to Webhook" to test delivery.
Generate an API key (shown once — copy it immediately). Use as ?apiKey=<key> query param or Bearer header. Returns JSON or base64-encoded CSV ZIP.
Choose "Junction table" mode to create a separate link table per multi-value attribute, or "Flatten" to keep them as comma-separated strings.
| Symptom | Cause | Fix |
|---|---|---|
| "No schemas found" in Step 1 | Assets / CMDB is not enabled or no schemas exist | Verify JSM Standard or above. Create a schema with at least one object type. |
| Export returns 0 objects | Object types are selected but contain no objects | Verify the selected object types have actual objects. |
| Export status shows "Partial (capped)" | More than 10,000 objects across all selected types | Reduce the number of selected schemas or object types. |
| Pull endpoint returns 401 | Missing or invalid API key | Generate a key and use it as ?apiKey=<key> or Bearer header. |
| Webhook test shows "Failed" | URL is unreachable or returns a non-2xx status | Try https://webhook.site for a free test endpoint. |
For support enquiries: support@3t-apps.com
Support hours: Monday–Friday, 9:00 AM–5:00 PM CET. Target response time: 1 business day.