Ask natural-language questions about the AMEND environmental database and get interactive charts and maps as answers.
Type a question, and an AI model will generate and run a SQL query against the full database, then interpret the results for you.
Supported providers: Groq (free, default),
OpenAI, and
Google Gemini — bring your own API key.
How to use Ask AMEND AI
Load the database — click "Load Database" and wait for it to finish (~84 MB, cached after first load).
Add your API key — open API Settings, paste a free Groq key, and save.
Ask a question — click a starter question or type your own, then press Ask.
Explore the results — interact with the chart, view the generated SQL, or browse the raw data table.
⚠️ AI Analysis Disclaimer: The SQL queries and charts below are generated by AI based on public data aggregated in the AMEND database and may be inaccurate, misinterpret the data, or miss important context.
Checking for cached database…
0%
API Settings
✓ Saved
About AI Analysis: This feature uses AI to generate SQL queries and analyze your data.
Results are generated entirely client-side and may contain errors, misinterpretations, or incomplete analysis.
The LLM may hallucinate column names, provide SQL with bugs, or draw conclusions not supported by the data.
API Key Security: Your API key is stored in your browser's localStorage in plain text and is not encrypted.
On shared machines, any JavaScript on this page or browser extensions could access it.
Recommendation: Use restricted/temporary API keys with rate limits or expiration dates if your provider supports them.
On shared machines, clear localStorage after use by opening the console (F12) and running localStorage.clear(), or use private browsing.
Privacy: Your API key is never sent to our servers. Queries and results are sent to your chosen LLM provider (Groq, OpenAI, or Google).
Cost: OpenAI and Google Gemini are paid services; check provider pricing. Groq offers free tier (20 req/min).