The Scenario
You're a DevOps engineer. You self-host NocoDB for 15 teams inside your organization, and you have a storage capacity review coming up with the infrastructure committee next week. The committee wants a structured inventory: every workspace, every base inside each workspace, the base IDs. They want it in an Excel workbook so they can sort, annotate, and share it with the teams ahead of the upgrade decision.
The bad version:
- Log into the NocoDB admin panel, navigate to workspace management, open the first workspace.
- Manually note the workspace name, then open each base under it and copy the base name and ID into a document.
- Repeat for all 15 workspaces — plus however many bases they contain — without losing count.
The infrastructure committee doesn't need you in that meeting as a person who spent three hours doing data entry. They need you as the engineer who's been managing this deployment. The workbook is supposed to be background prep, not the job itself.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to your NocoDB instance through its built-in integration and can walk the entire workspace and base hierarchy, writing everything into your workbook with one instruction.
Export every NocoDB workspace and base into this Excel sheet — one row per base with workspace name, base name, and base ID in columns A, B, and C
What You Get
- Column A contains the workspace name, repeated for each base that belongs to it.
- Column B contains the base name.
- Column C contains the base ID.
- One row per base, making it easy to sort by workspace or filter by ID range.
- The workbook is ready to share with the committee without further formatting.
What If the Data Is Not Quite Ready
Some workspaces are empty and should be flagged rather than skipped
List all NocoDB workspaces and their bases into columns A, B, C — if a workspace has no bases, write the workspace name in column A, leave column B blank, and write 'NO BASES' in column C
You need creation dates alongside the base IDs for a capacity timeline
List all NocoDB workspaces and bases — write workspace name in A, base name in B, base ID in C, and creation date in D — sort by creation date ascending
The committee also needs a count of tables per base
List all NocoDB workspaces and bases into columns A, B, C — then for each base, fetch the table count and write it into column D
Full kill-chain: inventory, table counts, and a summary row per workspace
List all NocoDB workspaces and bases — columns A through D for workspace name, base name, base ID, and table count — then after the last base for each workspace, insert a summary row with the total base count and total table count for that workspace
One prompt builds the full structured report. No pivot table, no manual grouping.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook before your next infrastructure review, then ask it to pull the full NocoDB workspace and base inventory. Pair it with Fetch NocoDB Instance Stats Into an Excel workbook and the NocoDB integration overview.