Sqlectron

Name: Sqlectron — Download page. Multi-database SQL client
Availability: InStock
Rating: 5 (1 reviews)
Author: Mark Nunes

Sqlectron — Free Download. Multi-database SQL client

A lightweight desktop and terminal SQL client with support for multiple databases and platforms. Manage connections, execute queries, and visualize data from a unified interface.

★★★★★

5.0(1 ratings)

Download Sqlectron (Official links)

File size: 172 MB

The latest version of Sqlectron is: 1.39.0

Operating system: Windows, Linux, MacOS

Languages: English

Developer: Mark Nunes

Price: $0.00 USD

Multi-database support. Simultaneous connection to PostgreSQL, MySQL, Microsoft SQL Server, MariaDB, SQLite, Cassandra, Redshift, and CockroachDB. Credential and specific parameter management is handled from the centralized connection settings.
SQL query execution. Integrated editor with the ability to write and execute SQL commands. Results are displayed in a table format with scrolling, filtering, and column reordering capabilities.
Syntax highlighting. Visual identification of SQL keywords, functions, text strings, and comments within the editor. The color palette distinguishes language elements for code review.
Schema explorer. Hierarchical navigation of databases, tables, views, stored procedures, and functions. The structure updates when objects on the connected server are modified.
Automatic query formatting. Restructuring of SQL code according to predefined style conventions. The feature organizes indentation, line breaks, and uppercase for language keywords.
Tunneled SSH connections. Configuration of SSH tunnels to access databases on remote servers. Supports private key and SSH agent authentication.
Query history. Chronological storage of SQL commands executed during the session. Allows retrieval and re-execution of previous queries without needing to rewrite them.
Result export. Conversion of query result sets to CSV and JSON formats. Files are generated with UTF-8 encoding and configurable delimiters.
Multiple workspace tabs. Opening several connections and queries in independent tabs. Each tab maintains its own state and results without interfering with other active sessions.
Full-screen mode. Expansion of the editor and results area to the entire application window. Hides interface elements for focused writing and data analysis.
Configurable keyboard shortcuts. Assignment of key combinations for frequent actions such as executing a query, formatting code, or switching between tabs. Settings are saved per user.
Search in results. Filtering of rows in datasets using text criteria. The search applies in real-time across all visible columns in the results table.
Connection URI. Use of URI strings to define database connection parameters. The format consolidates host, port, database, and credentials into a single line of configuration.
Connection cloning. Duplication of existing connection configurations to create variants. This feature avoids manually rewriting common parameters between similar servers.

The application has been under development since 2015. The initial team included Mark Nunes and other collaborators. Active development continues with community contributions. The project is built with Electron, TypeScript, and React. The architecture separates main and renderer processes. Communication between processes uses IPC calls. Testing includes unit and end-to-end scenarios. The sqlectron-core module was integrated into the main package. The database layer uses the sqlectron-db-core module. The conversion to TypeScript is in progress. Components are being migrated to pure functions and React hooks.