Generate SQL for your Database

Our natural language database interface allows non-technical users to obtain easy access your company's data without using a structured query language. Users simply ask for what they want in their own words. We provide an SQL output, which is used to query your database.
How it Works

Demonstration

The following three sample databases are used to demonstrate the Natural Language Database Query system. You can view the data in the databases, query the databases in natural language, see the generated SQL, and verify the results in the database. Some sample questions are included to show the variety of questions that can be handled. (Note: data in World Country database are not current.)

Northwind Traders Database

Company Employee Table

World Country Database

This is a database for a fictitious specialty foods import/export company. It includes tables for products, customers, suppliers, orders, and employees. View Database

Sample Questions	SQL Results
What is the cost of Northwoods Cranberry Sauce?	SELECT products.UnitPrice FROM northwind.products where products.ProductName = 'Northwoods Cranberry Sauce';
Do you have Chef Anton's Cajun Seasoning?	SELECT products.ProductName FROM northwind.products where products.ProductName = 'Chef Anton''s Cajun Seasoning'
Tell me the number of Aniseed Syrup in stock?,	SELECT products.UnitsInStock FROM northwind.products where products.ProductName = 'Aniseed Syrup'
How many customers do you have in Germany?	SELECT count(*) AS Number FROM northwind.customers where customers.Country = 'Germany';
Tell me the products that you sell?	SELECT products.ProductName FROM northwind.products Limit 30;

This is a single-table database with employee data, such as, employee name, email address, phone number, address, work site, department, date of hire, salary, date of birth, etc. View Database

Sample Questions	SQL Results
Show me all employees in New York?	SELECT hrx.fname, hrx.lname FROM nlp.hrx where hrx.work_site = 'new york' Limit 30;
Show me the name, phone number and hire date of all employees who were hired before 12/24/1999,	SELECT hrx.lname, hrx.fname, hrx.work_phone, hrx.hire_date FROM nlp.hrx where hrx.hire_date<'1999-12-24' Limit 30;
How many children does Thomas Axen have?	SELECT hrx.number_of_children FROM nlp.hrx where hrx.fname = 'thomas' AND hrx.lname = 'axen';
What is the phone number and home address of Vazwer Mizpol?	SELECT hrx.work_phone, hrx.home_address FROM nlp.hrx where hrx.fname = 'vazwer' AND hrx.lname = 'mizpol';

This is a sample database with information on the countries of the world. It includes tables for countries, cities, and languages. View Database (Data not current)

Sample Questions	SQL Results
What is the capital of Chile?	SELECT city.Name FROM world.country INNER JOIN world.city ON world.city.ID=Country.Capital where country.Name = 'Chile' Limit 30;
Show me countries and population in Eastern Europe.	SELECT country.Name, country.Population FROM world.country where country.Region = 'Eastern Europe' Limit 30;
Show me the surface area of Germany	SELECT country.SurfaceArea FROM world.country where country.Name = 'Germany' Limit 30;
What is the form of government of China?	SELECT country.GovernmentForm FROM world.country where country.Name = 'China' Limit 30;
Show me countries and surface area in the caribbean with area less than 2000 sq km.	SELECT country.Name, country.SurfaceArea FROM world.country where country.Region = 'Caribbean' AND country.SurfaceArea<'2000' Limit 30;

Type your question below in your own words.