AI Tools for Database Query & Design

DatabaseSpy AI Assistant

  • Altova AI integration
  • SQL editor AI extensions
  • Generate SQL from natural language prompts
  • Accelerate query development
  • Generate sample database data
  • Create table relations
  • Explain complex SQL statements
  • Explain errors and troubleshoot

Altova AI in the SQL Editor

DatabaseSpy integrates with the Altova AI Server, an Altova-hosted service that brings context-aware AI assistance into the SQL editing environment. Available as an optional add-on, it provides smart support for query writing, data modeling, error resolution, and more.

The AI Assistant in DatabaseSpy consists of two tools:

  • AI Chat Dialog
  • AI Extensions

The AI Chat Dialog allows you to send requests to the Altova AI Server to create sample SQL statements, create sample data for a given table structure, create relations between tables that have no keys yet, and so on. Once you send a request and receive the response, you can copy and paste the returned SQL into an existing file or create a new SQL file with the response.

Using the AI Assistant to generate SQL in DatabaseSpy

SQL Editor AI Extensions

In addition to the AI Chat Dialog, the DatabaseSpy SQL Editor menu includes AI-powered extensions that help you increase productivity:

  • AI-complete: Generate SQL statements, tables, etc.
  • AI-explain: Describe what a particular statement will accomplish when executed (shown below)
  • AI-explain-error: When a statement execution throws an error, a link is provided in the Messages window to request more information and troubleshooting steps
  • Pretty-print: Format SQL code to make it easier to read and understand
Using Altova AI in DatabaseSpy to explain what a SQL statement does

This built-in AI functionality in DatabaseSpy will increase productivity and accelerate learning when designing and developing queries or otherwise working with the data from relational databases.

Start Your Altova AI Subscription

Altova AI is available via a subscription that customers purchase in addition to their product license. A Support and Maintenance Package (SMP) is required for purchasing Altova AI. Customers may purchase an Altova AI subscription at the same time as a new SMP or add it to an existing SMP subscription. Visit the Altova Online Shop to review all your options and start your Altova AI subscription.

Subscribe
Start an Altova AI Subscription Now
  • YouTube
  • LinkedIn
  • X
  • Facebook
Use of this site is governed by our Terms of Use, Privacy Policy & Cookie Policy. Copyright 2005-2026 Altova. All Rights Reserved. Patents Pending.