Docs
User guide
Back to website ->

SQL Assistant

Suggest Edits

SQL Assistant in PopSQL helps you write, fix, and organize SQL faster and more accurately.

When to Use SQL Assistant

Use SQL Assistant to simplify SQL tasks and save time:

  • Understand Functions: Need to know how a function like LAG() works? SQL Assistant explains it with examples.
  • Diagnose Errors: If your query fails, SQL Assistant identifies the issue and suggests a fix.
  • Interpret Complex Queries: Get a breakdown of each part of a dense query.
  • Optimize Queries: For slow queries, SQL Assistant suggests ways to improve performance.

Demo

Try SQL Assistant in PopSQL to see how it helps with query generation, error diagnosis, and organization.

Key Capabilities

SQL Assistant offers a range of features to improve your SQL workflow, including real-time help, error resolution, and query organization:

Real-Time Help

SQL Assistant provides in-context help for writing and understanding SQL. Use it to:

  • Understand functions: Get examples and explanations of functions like LAG() or ROW_NUMBER() tailored to your database.
  • Interpret complex queries: SQL Assistant breaks down dense queries, giving you a clear view of each part.

Error Resolution

SQL Assistant diagnoses errors as they happen, so you can resolve issues without leaving your editor. Features include:

  • Error debugging: SQL Assistant identifies common issues and suggests fixes in real time.
  • Performance tuning: If your query is slow, SQL Assistant provides optimization suggestions to improve performance immediately.

Generate Titles and Descriptions

SQL Assistant automatically adds titles and summaries to queries, keeping your query library organized and for your team to understand the purpose of each query.

Limitations to Keep in Mind

For best results with SQL Assistant:

  • Schema Awareness: SQL Assistant uses schema data but may need extra context in complex setups. Specify tables, columns, or joins as needed.
  • Business Logic: SQL Assistant doesn’t know your specific business terms (e.g., “active user”). Define these terms for better results.

Security and Privacy

We prioritize your security and privacy:

  • Opt-In Features: All AI features are off by default. Only admins can enable them.
  • Data Protection: Your queries and data remain private and aren’t used for AI training.
  • Secure Environment: SQL Assistant operates with strict security protocols.

Admins can manage SQL Assistant settings in Preferences > SQL Assistant.

Data Usage and Privacy

To provide AI support, we may share the following data with our AI partners:

  • Query title, description, and body
  • Connection type (e.g., PostgreSQL, Snowflake) and schema
  • Sample data (if enabled under Preferences > SQL Assistant > Sample data)

To improve service, we collect telemetry and usage data, including prompts, responses, and query metadata.

Current Pricing

SQL Assistant is currently free for all users. In the future, limits or paid options may be introduced as we work to build the best experience.

Availability

SQL Assistant is available on all platforms:

Updated about 1 month ago

Cookie settings