Selekta documentation
How to install Selekta on a Mac, connect to PostgreSQL, MySQL, SQLite and SQL Server, and work safely with production data.
- DOC 01Install Selekta on your MacPick the Apple Silicon or Intel build, install Selekta from the .dmg, open it past Gatekeeper and keep it current with signed in-app updates.
- DOC 02Getting started with SelektaYour first minutes in Selekta: the Welcome screen, adding and testing a connection, the navigator, a first query and reading the title block.
- DOC 03ConnectionsHow to create, test and organise database connections in Selekta, with environment tags, folders, read-only mode and passwords kept in the Keychain.
- DOC 04SSH tunnels and TLSReach private databases through an SSH tunnel or OpenVPN, choose an SSL mode, add CA and client certificates, and pin a server certificate in Selekta.
- DOC 05PostgreSQLWhat Selekta does with PostgreSQL connections: ports, authentication, session time zone, poolers, read-only sessions, Explain, PostGIS and known limits.
- DOC 06MySQL and MariaDBHow Selekta connects to MySQL and MariaDB: port, authentication, sql_mode and time zone, DELIMITER scripts, implicit commits, Explain and current limits.
- DOC 07SQLiteOpen an existing SQLite file or create a new one in Selekta, use read-only mode, and see how Explain, backups and the navigator work for SQLite.
- DOC 08SQL ServerHow Selekta works with SQL Server: SQL logins on port 1433, encryption options, GO batches, showplan Explain, read-only intent and what is not supported yet.
- DOC 09RedisSelekta with Redis: password or ACL user, TLS, database index, a key browser built on SCAN, string and hash editing, TTL and a redis-cli style console.
- DOC 10SQL editorRun one statement or a whole script, cancel a slow query, bind parameters, format SQL, and save scripts or find past queries in history.
- DOC 11Results and editing dataRead, filter and copy result rows, inspect values and records, then edit table data as revisions you review as SQL before you apply or commit.
- DOC 12Production safetyHow environment tags, the title block, the typed confirm, manual commit and read-only connections keep you from changing the wrong database.
- DOC 13Structure editorAdd, rename, change and drop columns, indexes and foreign keys, or create a table, and review the generated DDL before it runs on the server.
- DOC 14Schema diagramOpen a diagram of the tables and foreign keys in one schema, focus on a table and its neighbours, and save it as PNG, SVG or Mermaid text.
- DOC 15Explain plansSee how the database will run a statement, or how it ran it, as a tree with costs, row counts and timings, on PostgreSQL, MySQL, SQL Server and SQLite.
- DOC 16Maps for geometry columnsDraw PostGIS and MySQL geometry columns on a map beside the results, reproject common SRIDs to WGS 84, copy WKT or GeoJSON, and set your own tile server.
- DOC 17Export and import dataExport a table or query result to CSV, JSON, SQL INSERT or XLSX, and import a CSV file into a table with column mapping, checks and rollback.
- DOC 18Backup and restoreBack up and restore PostgreSQL and MySQL databases with pg_dump, pg_restore, mysqldump and mysql, and SQLite files with no extra tools.
- DOC 19Keyboard shortcutsEvery keyboard shortcut in Selekta, the Selekta and Classic presets, and how to record your own key for any action in Settings › Shortcuts.
- DOC 20SettingsWhat every option in Selekta Settings does: theme and zoom, editor, data grid, map tiles, shortcuts, backup tools, security and updates.
- DOC 21Privacy and crash reportsWhat Selekta sends from your Mac and what stays on it: update checks, opt-in crash reports and their scrubbing, map tiles, and passwords in the Keychain.
- DOC 22TroubleshootingThe error messages Selekta shows when a connection, query, backup or import fails, what each one means, and how to fix it.