Automate your SQL queries

A lot of people run the same query every day, save the results and mail it to someone to take action. AutoSQL helps you to automate this process. Just specify your ODBC connection, query, output definition and mail options once. Schedule your SQL query to run at any time in the background. Query automation made easy!

Specify a query and ODBC connection

Schedule SQL query

Export results to Excel or CSV

Send results through email

How it works

  • Use the AutoSQL GUI to create a new task list
  • Add a new action
  • Choose an ODBC connection and specify a SQL query
  • Determine where the output needs to be saved, either in Excel or CSV format
  • Choose to send the result by email, or only based on a certain amount of records
  • Link the output file or send it directly as an attachment

When you have defined all actions that need to be scheduled together, save your task list. Now copy the background execution command to the clipboard and schedule it using eg Windows Task Scheduler.

Schedule your SQL query and relax

ODBC & SQL

AutoSQL works with all databases that support ODBC. There is specific version to run with 32 and 64 bit drivers. AutoSQL has been tested with:

  • Microsoft Access
  • Microsoft SQL
  • Oracle
  • PostgresSQL
  • MySQL
  • SAP HANA
  • Many more...

Output options

Each action defines an output:

  • Output path
  • Can be both local or network
  • Use {date} place holder in filename
  • Excel or CSV
  • Specify sheet and cell to use with Excel
  • Use Excel template to define formatting
  • Detailed specification of CSV format
  • Append or overwrite
  • Print or disable header

Email options

After the execution of a query, you can choose to send an email.

  • Send only email when more than X records (e.g. don’t send anything when there are no results)
  • Use place holders for number of rows, date, output path and the query to use in the subject and message
  • Optionally attached the output file and ZIP it if required

How to

Download the trial version and check out our tutorials on how to schedule a query in 3 easy steps or how to export a SQL query to Excel and pre-define formatting..

Or watch the video below to see how easy it is to schedule a SQL query and mail the results every week:

More videos:

Is your database system not covered in the videos? Don't worry, almost all databases work with ODBC and can be used with AutoSQL.

Download 30 day trial

You can download AutoSQL and request a 30 day trial license to see if AutoSQL can help you make your life easier!


Choose an ODBC connection and put in your SQL query

On the output tab you can choose the output type and email options

In General settings you choose the SMTP server, CSV options and wether you want to receive an email if there is an error

When your actionlist is done click on 'Get Background Command' and use it in eg Windows Task Scheduler

In the email message and subject you can use placeholder like date and number of rows

Optionally specify an Excel template for formatting, a specific sheet and cell to put the data