Flexible Data Importer
Skill by sschepis
Why use this skill?
Automate data ingestion from CSV, JSON, and XLSX files directly into Supabase with the Flexible Data Importer OpenClaw skill.
Install via CLI (Recommended)
clawhub install openclaw/skills/skills/sschepis/flexible-data-importerWhat This Skill Does
The Flexible Data Importer by sschepis is a sophisticated ingestion engine designed for OpenClaw users who need to bridge the gap between flat files and relational databases. Rather than requiring manual table creation or tedious SQL scripting, this skill uses an AI-first approach to analyze source files. It reads CSVs, JSON arrays, and Excel workbooks, interprets the underlying data types, and automatically constructs a corresponding schema in your Supabase environment. By handling everything from column casting to relationship inference, it simplifies the ETL (Extract, Transform, Load) process into a single, seamless operation.
Installation
To integrate this skill into your OpenClaw environment, execute the following command in your terminal:
clawhub install openclaw/skills/skills/sschepis/flexible-data-importer
Ensure that you have your Supabase Project URL and Service Role Key configured within your environment variables or session secret store to allow the skill to perform DDL (Data Definition Language) operations.
Use Cases
- Migrating Legacy Data: Quickly move CSV exports from old legacy software into a modern, queryable Supabase database.
- Rapid Prototyping: Import JSON data from external API responses to iterate on new app features without manually drafting migrations.
- Financial Reporting: Import monthly Excel budget sheets to immediately perform cross-table analytics via SQL.
Example Prompts
- "Data Importer, take the file located at ./data/users_export.csv and push it to my Supabase instance, making sure to detect dates correctly."
- "I have a large JSON file at ./raw/analytics.json. Use the flexible-data-importer to parse it and build a new table named 'web_events'."
- "Please import ./finance/q3_report.xlsx into Supabase. Note that the 'amount' column should be treated as a float."
Tips & Limitations
For optimal results, ensure your source files contain headers; while the AI attempts to infer headers, explicitly defined column names yield higher schema accuracy. For massive datasets exceeding 100MB, use the batched upload feature to prevent memory overflow errors. Note that this skill requires direct network access to your Supabase project; ensure your database firewall or API permissions allow traffic from the OpenClaw agent's IP range. Always review the auto-generated schema after the first import run to ensure specific index requirements are met.
Metadata
Not sure this is the right skill?
Describe what you want to build — we'll match you to the best skill from 16,000+ options.
Find the right skillPaste this into your clawhub.json to enable this plugin.
{
"plugins": {
"official-sschepis-flexible-data-importer": {
"enabled": true,
"auto_update": true
}
}
}Tags(AI)
Flags: network-access, file-read, external-api