Datasets Module
Create spreadsheets, CSVs, JSON, databases, APIs, and structured data projects.
Overview
The Datasets module handles all structured data deliverables. Whether you need a CSV report, an Excel spreadsheet with charts, a JSON dataset, or a complete data API, this module generates production-ready data artifacts. Supports: - Spreadsheets - XLSX with styled headers, multiple sheets, auto-sizing - CSV Files - Clean, properly-escaped tabular data - JSON Datasets - Structured data collections - Data APIs - FastAPI/Express endpoints for data access - Database Schemas - SQL schemas and seed data - Data Visualizations - Charts and dashboards
Getting Started
- Navigate to Dashboard > Datasets
- Click Create Dataset or describe what you need
- Select a framework (Tailwind for visual, Vanilla for raw data)
- The AI generates your structured data
- Preview, download, or publish
Supported Output Types
| Type | Format | Use Case |
|---|---|---|
| Spreadsheet | .xlsx | Reports, financial data, inventory |
| CSV | .csv | Data exports, imports, analysis |
| JSON | .json | API responses, configuration, datasets |
| SQL | .sql | Database schemas, seed data, migrations |
| Data API | Python/Node | REST endpoints for data access |
| Dashboard | HTML | Interactive charts and visualizations |
Features
AI Data Generation
Describe your data needs in natural language: - "Create a spreadsheet of 50 tech companies with name, revenue, employees, and founding year" - "Generate a JSON dataset of 100 sample products for an e-commerce store" - "Build a CSV of US state populations with historical data from 2000-2024"
Spreadsheet Generation
Uses the magnus_create_spreadsheet tool:
- Styled headers with colors and bold text
- Multiple sheets in one workbook
- Auto-sized columns
- Number formatting (currency, percentages)
- Formulas and calculated fields
AppDB Integration
Dataset projects with AppDB enabled can store and serve data dynamically: - Upload datasets to AppDB collections - Query and filter via the AppDB API - Build interactive data explorers
Frameworks
| Framework | Best For |
|---|---|
| Vanilla | Raw data files (CSV, JSON, XLSX) |
| Tailwind | Data dashboards, visualizations, interactive tables |
File Storage
Exported dataset files are saved to My Files > Datasets.
Tips
- Be specific about columns, data types, and row counts
- For large datasets, specify the structure and let AI generate sample rows
- Use Tailwind framework for interactive data visualizations
- AppDB is great for datasets that need to be queried or filtered client-side
- The data analyst role (
data_analyst) handles complex data transformations