Ask in plain English. Loam writes SQL from your table definitions.
Describe what you want to know. Loam uses the table names, column names, and data types it extracts in your browser to generate SQL. Review the query and any reference warnings, then run it in your own database.
When you generate SQL, the extracted table names, column names, and data types, plus your question and SQL dialect, are sent to Loam and its AI provider. Your original CREATE TABLE text stays in your browser.
Paste your schema above or load the sample to get started.
Was this useful?
Start with the definitions you paste
The tool starts with the table and column names you paste. After it generates SQL, Loam checks those references with a lightweight validator and warns about names it cannot match. The validator ties the request to the table and column names you provided, but it does not prove that the query is correct. Review the SQL before you run it. Learn more about grounding AI in source data.
Text to SQL turns a plain-English question into a query. Good SQL still depends on complete definitions and a clear question. Loam cannot check business meaning or result values on this page because it does not connect to your database.
Want to try a query on a file? The SQL playground runs SQLite queries on a CSV or TSV that you select separately. The CSV and TSV chat tool also uses a file selected on its own page. Your pasted definitions do not carry into either tool.
Frequently asked questions
How does Loam turn plain English into SQL?
Loam extracts table names, column names, and data types from the CREATE TABLE statements in your browser. It sends those extracted details with your question and chosen SQL dialect to Loam and its AI provider, then flags references it cannot match.
Does the SQL actually run, or is it just generated text?
It generates SQL but does not run it. Review the query and any reference warnings, then run it in your own database.
How is this different from asking ChatGPT to write SQL?
A general AI may not have your table and column names. This tool includes the names and data types it extracts and flags some references it cannot match. You should still review the SQL before running it.
What SQL dialects does it support?
The free tool on this page generates standard SQL for PostgreSQL, MySQL, SQLite, and Snowflake. Dialect-specific syntax like window functions and CTEs is adapted to the dialect you pick.
Can I use it without signing up?
Yes. Paste your CREATE TABLE statements, or load the sample, then ask in plain English and review the generated SQL. No account is required.
What information is sent when I generate SQL?
The tool extracts table names, column names, and data types in your browser. Those extracted details, your question, and the SQL dialect you choose are sent to Loam and the AI provider that generates the answer. The original CREATE TABLE text is not sent, and this page does not connect to or query your database.
Related tools
Connect your AI to your business data
The tool above only generates SQL from the definitions you paste. Start with Loam to upload data and connect your AI for ongoing questions.