astrasql is an AI-powered application that turns natural language into SQL queries. It prioritizes your privacy by only processing metadata. You can securely run it on your own server. astrasql supports various databases, including PostgreSQL, MySQL, SQLite, SQL Server, Oracle, and MongoDB.
Whether you are a business analyst, a data enthusiast, or just curious about databases, our tool helps you generate SQL commands quickly and easily.
To start using astrasql, follow these steps:
Ensure your system meets the following basic requirements:
- Operating System: Windows 10 or later, MacOS, or a recent version of Linux
- RAM: Minimum 4GB
- Storage: At least 200MB of free space
- Database: Ensure you have one of the supported databases installed
To download the latest version of astrasql, visit the Releases page here.
On the Releases page, you will see a list of available versions. Look for the latest version indicated at the top. Click on the link for your operating system to download the installer file.
Once the download is complete, follow these steps based on your operating system:
- Locate the downloaded
.exefile in your Downloads folder. - Double-click the file to start the installation.
- Follow the on-screen prompts to complete the installation.
- Locate the downloaded
.dmgfile in your Downloads folder. - Double-click the file to open it.
- Drag the astrasql icon to your Applications folder.
- Open a terminal window.
- Use the package manager to install. For example:
sudo dpkg -i astrasql*.deb - Follow any additional on-screen instructions.
After installation, launch the application using the following methods:
- Windows: Find astrasql in your Start Menu and click to open.
- MacOS: Open your Applications folder, and double-click on astrasql.
- Linux: Use the terminal to run
astrasqlor find it in your applications menu.
Upon launching the app, you will need to connect to one of the supported databases. Follow these steps:
-
Click on the "New Connection" button.
-
Fill in the required fields:
- Database Type (select from the list)
- Host (usually
localhostfor local databases) - Port Number (default port for your selected database)
- Username and Password (if required)
-
Click on "Connect" to establish the connection.
- In the text box, type your question or command in natural language. For example, "Show me all the users from the last month."
- Click the "Convert" button.
- The application will generate the corresponding SQL query. You can run this query directly in your connected database.
If you need help or have questions about using astrasql, you can reach out to the community through our GitHub Discussions page. You can also find FAQs and troubleshooting tips in the Issues section.
astrasql is open-source software, licensed under the MIT License. You can modify and distribute it as per the conditions laid out in the license file.
Feel free to explore, ask questions, and enjoy your experience with astrasql!