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. The natural language queries originate from users at your website. These queries are forwarded to sageNLP.com for processing and a structured response (SQL) is returned. The communication between your website and SageNLP.com occurs in the background and the response is nearly immediate. Your website uses the structured response to query your database and return a response to the user. 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: (columns: [ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued]), categories: (columns: [CategoryID, CategoryName, Description]), suppliers: (columns: [SupplierID, SupplierName, ContactName, Address, City, PostalCode, Country, Phone]), orders: (columns: [OrderID, CustomerID, EmployeeID, OrderDate, ShipperID]), order_details: (columns: [OrderDetailID, OrderID, ProductID, Quantity]), employees: (columns: [EmployeeID, LastName, FirstName, Title, TitleOfCourtesy, BirthDate, HireDate, Address, City, Region, PostalCode, Country, HomePhone, Extension, Photo, Notes, ReportsTo, PhotoPath, Salary]), customers: (columns: [CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax]), shippers: (columns: [ShipperID, CompanyName, Phone]). 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;

Sample Questions	SQL Results
Find the names and birthdates of all employees	SELECT first_name, last_name, birth_date FROM employees;
List the employees' names who are currently working in the "Sales" department.	SELECT e.first_name, e.last_name FROM employees e JOIN dept_emp de ON e.emp_no = de.emp_no JOIN departments d ON de.dept_no = d.dept_no WHERE d.dept_name = 'Sales' AND de.to_date > CURRENT_DATE;
Who is the manager of Thomas Axen have?	SELECT employees.first_name, employees.last_name, departments.dept_name FROM employees JOIN dept_emp ON employees.emp_no = dept_emp.emp_no JOIN dept_manager ON dept_emp.dept_no = dept_manager.dept_no WHERE employees.first_name = 'Thomas' AND employees.last_name = 'Axen';"
What is the current salary of the employee of Vazwer Mizpol?	SELECT salaries.salary FROM employees JOIN salaries ON employees.emp_no = salaries.emp_no WHERE employees.first_name = 'Vazwer' AND employees.last_name = 'Mizpol' AND salaries.to_date = '9999-01-01';
Find the titles of all employees who have been in the company for more than 5 years.	SELECT e.first_name, e.last_name, t.title FROM employees e JOIN titles t ON e.emp_no = t.emp_no WHERE e.hire_date < CURRENT_DATE - INTERVAL 5 YEAR;
Which employees are currently managers in the "Technology" department?	SELECT e.first_name, e.last_name FROM employees e JOIN dept_manager dm ON e.emp_no = dm.emp_no JOIN departments d ON dm.dept_no = d.dept_no WHERE d.dept_name = 'Technology' AND dm.to_date > CURRENT_DATE;
What is the average salary of employees in the "Engineering" department?	SELECT AVG(s.salary) AS avg_salary FROM salaries s JOIN dept_emp de ON s.emp_no = de.emp_no JOIN departments d ON de.dept_no = d.dept_no WHERE d.dept_name = 'Engineering' AND s.to_date > CURRENT_DATE;
List all employees with their department names and their titles	SELECT e.first_name, e.last_name, d.dept_name, t.title FROM employees e JOIN dept_emp de ON e.emp_no = de.emp_no JOIN departments d ON de.dept_no = d.dept_no JOIN titles t ON e.emp_no = t.emp_no WHERE de.to_date > CURRENT_DATE;

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;