AutoSQL

AutoSQL is a TypeScript-powered zero-config ingestion library that automatically infers SQL schemas from JSON data and inserts it into MySQL or PostgreSQL. Version 1.1.1 supports automatic schema creation, alteration, batch inserts, and streaming with minimal configuration. It differs from traditional ORMs by requiring no model definitions or migration scripts, making it suitable for rapidly evolving data pipelines. Key features include type inference, primary key management, schema drift detection, and SSH tunneling support. The library is actively maintained, with the latest release focusing on stability and MySQL compatibility.