{"ok":true,"result":{"slug":"csv-to-sql","name":"CSV to SQL Converter","summary":"Turn CSV into SQL: an optional CREATE TABLE with inferred column types, then batched INSERT statements, quoted for PostgreSQL, MySQL, SQLite or SQL Server.","description":"Turn CSV into CREATE TABLE and INSERT statements for PostgreSQL, MySQL, SQLite or SQL Server, with inferred column types, safe quoting and batched inserts.","method":"POST","endpoint":"/api/v1/tools/csv-to-sql","plan":"free","mcpName":"csv_to_sql","input":{"type":"object","additionalProperties":false,"properties":{"input":{"type":"string","description":"The CSV text.","maxLength":200000},"dialect":{"type":"string","description":"SQL dialect, which decides identifier quoting, string escaping and type names.","default":"postgresql","enum":["postgresql","mysql","sqlite","sqlserver"],"maxLength":200000},"tableName":{"type":"string","description":"Table name, optionally schema-qualified (public.customers).","default":"my_table","maxLength":200},"delimiter":{"type":"string","description":"CSV delimiter: \"auto\" to detect, or a single character.","default":"auto","maxLength":4},"header":{"type":"boolean","description":"Use the first row as column names; otherwise columns are column_1, column_2…","default":true},"createTable":{"type":"boolean","description":"Start with a CREATE TABLE statement.","default":true},"batchSize":{"type":"integer","description":"Rows per INSERT statement (1 to 1000).","default":100,"minimum":1,"maximum":1000},"emptyAsNull":{"type":"boolean","description":"Write NULL for every empty cell. When false, empty text cells become '' and other empty cells NULL.","default":false},"inferTypes":{"type":"boolean","description":"Infer INTEGER, BIGINT, REAL, BOOLEAN, DATE and TIMESTAMP columns; when false every column is TEXT.","default":true}},"required":["input"]},"example":{"input":"id,name,active\n1,Ada,true\n2,O'Brien,false","tableName":"customers"},"randomOutput":false,"network":false,"docs":"https://pithlab.com/developers/tools/csv-to-sql","page":"https://pithlab.com/tools/csv-to-sql"}}