Transform how you interact with databases. Run regular SQL queries or convert plain English into SQL with automatic PII detection and schema intelligence.
Powerful database interaction that combines the precision of SQL with the flexibility of natural language.
Ask questions in plain English and get accurate SQL queries that understand your database schema.
Every data modification is analyzed for personal information like emails, names, and phone numbers.
Your database metadata stays current automatically, learning table structures for better AI queries.
When you ask SmartSQL to "find users who haven't logged in recently," several processes work together seamlessly.
The system examines your request and current database metadata to understand relevant tables and columns.
AI models convert natural language into proper SQL using safety tokens to prevent injection attacks.
Generated queries run against your database with results formatted as JSON or CSV for easy integration.
Background processes check for personal information and update detection records for compliance tracking.
Schema changes trigger metadata updates so future queries understand your database structure better. AI models continuously learn from your database patterns for improved accuracy.
SmartSQL operates through specialized services that handle different aspects of query processing with reliable background operations.
Coordinates query execution, handles both SQL and natural language inputs, and manages the overall request lifecycle.
Runs background analysis on data modifications using Hugging Face models to identify personal information across multiple entity types.
Maintains current database schema information, including table structures, column types, and sample data for AI context.
Services communicate through message queues for reliable background processing, ensuring operations complete without blocking responses.
SmartSQL excels in specific scenarios while other approaches may be better suited for different use cases.
When you need to ask questions about your data but aren't sure of the exact SQL syntax.
Applications that need to track and monitor personal information across database operations.
Databases where table structures change and you need AI to understand the current layout.
Applications requiring both precise SQL control and flexible natural language access.
Complex analytical workloads might need specialized database tools and optimized query engines.
Basic create/read/update/delete operations work fine with standard database bindings.
Natural language processing adds latency that might not suit millisecond-critical applications.
Query processing includes multiple safety layers that prevent malicious usage while preserving legitimate flexibility.
Safety token validation ensures generated SQL matches original intent and hasn't been manipulated.
Generated queries use standard parameterization and validation before execution following security practices.
Personal information detection results are stored in separate system tables with indexed lookups.
External API access requires JWT tokens with proper user and organization claims for authorization.
SmartSQL connects precise database control with flexible natural language queries for various integration scenarios.
Use direct SQL for known operations and natural language for exploration and user-facing interfaces.
SmartSQL detects and tracks personal information as your application processes data for compliance documentation.
As your database structure changes, SmartSQL adapts its understanding automatically for current AI query generation.