4 ms·
It is also shockingly good at converting/extracting data to CSV or JSON, but not JSONL. Even the less capable model, `gpt-4o-mini`, can "reliably" parse databas
by l5870uoo9y 2y ago
It is also shockingly good at converting/extracting data to CSV or JSON, but not JSONL. Even the less capable model, `gpt-4o-mini`, can "reliably" parse database schemas in various formats into CSV with the structure:
```csv
table_name,column_name,data_type
table_name,column_name1,data_type
table_name,column_name2,data_type
...
```
I have been running it in production for months[1] as a way to import and optimize database schemas for AI consumption. This performs much better than including the `schema.sql` file in the prompt.
[1]: https://www.sqlai.ai/app/datasources/add/database-schema/ai-optimized-import https://www.sqlai.ai/app/datasources/add/database-schema/ai-...