Send query results by mail
When your SQL query returns results, you can write it to Excel or CSV, but also email it directly to your audience. Use all kind of place holders to dynamically write the email text.
Fast and Easy
From SQL query to Excel attachment in less than 3 minutes
Define a connection and query, specificy required output and schedule it
Write SQL query
Setup an ODBC connection to any database supporting it and write your SQL query.
Define output
Write your query result to the network or local drive in Excel, CSV or HTML format
Send by mail
Send the results by mail. Make it conditional by doing this only if there are results
Schedule
Schedule it to run at any time or any interval using Windows build in scheduling engine
Supports all major databases
AutoSQL works with all major databases that support ODBC like Microsoft SQL server, MySQL, Oracle, PostgreSQL, IBM DB2, MS Access, SAP HANA and many more...
Automate Excel dashboards
When you want to update your Excel dashboard with SQL data, you can let AutoSQL fill a template Excel file. The final result can be put on the network or mailed directly to the business users.
watch and learn
Getting Started
Watch some of the video's below to learn how to use AutoSQL for this first time or about specific features
Download AutoSQL and start trial
Download the latest version of AutoSQL and start your 30-day free trial. The trial is fully functional for 30 days, so you can test your use case without limits
Start with AutoSQL in 3 steps
Learn how to use AutoSQL to automate and schedule any SQL query. Setup a connection to any database, provide a SQL query and schedule it to send a daily email with the results attached.
This video shows you have to setup AutoSQL and schedule your first SQL query.
Advanced formatting with Excel templates
Example with MySQL database
Example with MS Access
Customers
Customers all around the world
We are used in more than 35 different countries, with all kinds of different databases.
What customers tell us
Customer cases
“I tested AutoSQL and within 10 minutes I knew it was exactly what we needed. I love that I now have a way to track all sorts of ‘once in a blue moon’ events in our database and get an email when they actually happen.”
Maintenance planning for trucks at Bultsma Transport
Read more about Maintenance planning for trucks at Bultsma Transport
Report automation on SAP BusinessOne at TSE Imaging
Read more about Report automation on SAP BusinessOne at TSE Imaging
Saving 60% time creating reports at Multicaja SA
Read more about Saving 60% time creating reports at Multicaja SA
Preventing lost orders at Woodland Wine Company
Read more about Preventing lost orders at Woodland Wine Company