The SmartQL Blog
Notes on letting AI touch your database
Architecture, security, and the design decisions behind turning plain English into SQL you can actually run.
- 01
Adding an Intelligence Layer to Your Laravel App
A practical architecture for letting users ask questions of their data in plain English, drawn from how Trakli wires SmartQL into a Laravel application: an HTTP service, a queued job, a question router, and a semantic layer.
→ - 02
Give AI Your Whole Database. Just Not the Keys.
Teams are wiring LLMs directly into production databases. The payoff is real, and so are the failure modes. Here is the architecture that gets you the first without the second.
→ - 03
Parse the SQL. Don't Trust the Prompt.
Why SmartQL validates LLM-generated SQL with a real parser and an AST walk instead of system prompts and regex, with the actual checks it runs before a query touches your database.
→ - 04
SmartQL 0.1.0 Is on PyPI
The first public release of SmartQL: natural language to SQL with AST-based validation, a YAML semantic layer, and 100+ LLM providers. One pip install away.
→