v1.5.1

Bug fixes

• DELETE/UPDATE shortcuts no longer leak Rich markup into the
  generated SQL when run on markup-rendered result cells. Values
  like '[bold #FFFF00]1[/]' are now stripped back to '1'.
  Thanks @koianaoki. #243, #229
• Process worker is now fork-safe on macOS Tahoe (26.4+). Thanks @brentrager. #207, #189

Packaging

• Added a sqlit-tui entry point so the package can be launched
  with uvx sqlit-tui instead of
  uvx --from sqlit-tui sqlit. Thanks @nils-werner. #244

v1.5.0

Features

• Custom keybindings. Every action in sqlit can now be remapped
  to the keys you prefer, with your overrides reflected in the
  footer and help screen. Thanks @xtrasmal for kicking this off.
  #131, #225
• In-app keybinding editor on <space>k. Browse every binding,
  press a new key to rebind, or revert to defaults. No restart,
  no config file editing. #234
• Vim-style e/E end-of-word motions are available in the
  query editor for users who want to bind them. #233
• Query history is now stored as individual .sql files on
  disk. #226
• Project-scoped config. Run sqlit . in a project folder and
  connections, history, and starred queries live under
  .sqlit/. #226
• <space>o opens the current query in your $EDITOR. #226
• j/k now navigate the query history list. #232
• Help screen is context-aware: the section matching where you
  are (insert mode, results, explorer) shows first, and /
  filters bindings by substring. #235, #136
• Per-connection and per-database confirmation alerts. The
  effective mode falls back from database to connection to
  global, so you can tune confirmation per scope. #236
• Markdown export and a "Copy as…" submenu, joining CSV and
  JSON. A new chord also copies a column's values as a
  SQL-ready list. #237, #169
• Pick a subset of columns before copying or exporting via the
  new "Columns…" entry in the yank menu. #238
• Pipe secrets into the CLI with --password-stdin,
  --url-stdin, and --ssh-password-stdin instead of exposing
  them on the command line. #240, #158
• Pane labels and dialog shortcut hints now reflect your custom
  keymap instead of the defaults. #231

Bug fixes

• Cell values containing [/] no longer get mangled when
  copied. #230, #229
• First-time users now see n - New connection in the footer
  on an empty explorer. #223
• Moved n - New connection to the general Explorer section in
  the help screen. It works on any tree node, not just
  connection nodes. #228

v1.4.1

Features

• Open CSV, Parquet, and JSON files directly with the DuckDB
  connection. Point sqlit at a data file and it loads into a real
  table inside a per-process sidecar .duckdb so you can run full
  CRUD; write back with COPY <table> TO '<path>'. #213, #146
• Added Personal Access Token (PAT) authentication for Snowflake.
  Thanks @amankhandelia. #198
• Added DML RETURNING support so INSERT/UPDATE/DELETE statements
  display the returned rows. #219, #147
• Surface an actionable hint when Azure AD authentication fails for
  mssql. #209
• Cache the Entra token on disk for ad_default mssql so subsequent
  connects skip the prompt. #210
• Switched MariaDB to PyMySQL to drop the mysqlclient C dependency.
  #194
• Added more Firebird column types. Thanks @kgaughan. #190

Bug fixes

• Default an empty Postgres host to localhost when a port is set,
  so connections to non-default ports actually reach the server.
  #214, #205
• Fixed the explorer / filter dropping lazy-loaded tables in
  multi-database browse mode. #220, #141
• Stop expanding and collapsing tree nodes when navigating filter
  matches. Thanks @eibx. #206
• Land the cursor on the matched node after accepting a filter
  selection. #221
• Restored matches when backspacing in the explorer tree filter so
  widening the query brings them back. #211
• Escape user-typed text in the filter input to avoid Rich markup
  crashes (e.g. typing [). #212
• Render bytes as <BLOB N bytes> so blobs containing markup-like
  text don't crash the table render. #215, #202
• Fixed Oracle SID connections failing with DPY-4027. #185, #106
• Fixed MySQL autocomplete in multi-database setups. #184, #151
• Made query paste use reachable system clipboards. #193, #188
• Detect paramiko 4 incompatibility at connect time and route
  through the installer prompt. #217, #186
• Probe binary-protocol ports in test fixtures so the suite doesn't
  hang behind HTTP security agents. #218, #200
• Use sys.executable in the run_cli test helper so the right Python
  is invoked. #216, #199
• Distinguish uv tool install from uvx and emit correct install
  commands. #183, #133

v1.4.0

New database providers

• Added adapters for Impala, osquery, and SurrealDB.

Features

• Moved config storage to the XDG config directory, with
  automatic migration from ~/.sqlit. Thanks @ermengchao and
  @hrfried. #180, #174, #129
• Added password_command support for fetching passwords at
  connect time, including CLI flags for database and SSH
  passwords. Thanks @augustocdias. #165, #138
• Added Vim visual modes in the query editor. Thanks
  @chasleslr. #172
• Added more Vim-style navigation in the results view.
  Thanks @bussnet. #181, #170
• Added x and ^ keybindings in non-insert mode. Thanks
  @msoos. #140
• Updated the Nix flake to include bundled database drivers
  by default, plus a helper for custom driver sets. Thanks
  @joonnna and @sitaktif. #178, #154, #126
• Improved autocomplete dropdown sizing for long
  suggestions. Thanks @hexycat. #173
• Empty result sets now still show column headers. #176

Bug fixes

• Improved Teradata query classification and metadata
  handling. Thanks @ErwonB. #135
• Fixed PostgreSQL hangs when selecting bytea columns.
  Thanks @AlexZeitler. #171, #161
• Fixed silent process-worker hangs caused by pickle
  failures. Thanks again @AlexZeitler. #177
• Corrected the D1 adapter endpoint. Thanks @jegork. #179,
  #159
• Fixed HANA column lookup on HANA Cloud. Thanks
  @Pineappletooth. #182, #153
• Fixed Telescope errors on fresh start with no active
  connection. #164
• Fixed clipped last rows in stacked result tables. Thanks
  @Mrthnx. #163, #132

This release adds Google cloud spanner support (Thanks @fredrikaverpil)

Fixes MacOS crash #111
Adds CLI flag for choosing theme
Adds neovim plugin
Removes "Duplicate" keybinding from the bottom toolbar to optimize space
Rearrange items in the help menu
Improve terminal default theme

This release includes improvements giving you more control of what to execute and what to comment, among with more VIM features such as counted operations, line numbers (and relative line numbers setting), and lots of other quality of life fixes.

Features

• Add gruvbox-light theme (PR #92 by @kanlac)
• Add more basic VIM bindings for query editor: I, C, D (PR #95 by @BreitbandModem)
• Add counter vim motions, so that 3j and d3w works, etc.
• Add Supabase pooler shard option
• feat: add vim count prefix support for motions and operators
• Add query alert mode. This allows you to enable a confirm button for create/update and delete operations. issues: #81
• feat: add MotherDuck cloud support. issues: #103
• feat: pass extra_options to database drivers and add authentication settings for snowflake issues: #108
• Add ability toggle comment for current statement of cursor
• Add ability to toggle comment for selection (g+c+s) @LVG77
• Add ability to run current statement of cursor (g+s) @LVG77

Improvements and fixes

• fix: InMemory query history contains duplicates (PR #104 by @bivashy) — issues: #99
• fix: move Commands hint to left side for better discoverability (PR #105 by @koriyoshi2041) — issues: #83
• fix: Thai language (TIS-620) Unicode support for MySql
• Execute selection by default, fix comment execution — issues: #97
• Fix MySQL create database command — issues: #107
• Auto-refresh explorer after DDL commands
• Fix "update" via results keybinding not using primary key for generated SQL query
• Connect directly to an existing connection via CLI flag "-c "mydb" or --connection "mydb" — issues: #88
• Improve explorer refresh cursor restore
• Explorer filtering now hides the filtered away results in the connection explorer
• Auto-reconnect after driver installation— issues: #102
  -Fix refresh when adding connections via CLI while sqlit is running #100

• Keep query history for unsaved connections during the session and hide unavailable entries in Telescope\n- Fix autocomplete alias resolution for qualified tables\n\nFull Changelog: v1.2.10...v1.2.11

Changes\n- Remove e/E cursor motions in NORMAL mode (reserved for Explorer focus).\n- Keep e/E for operator motions and g-menu word-end-back.\n- Update help/docs and tests accordingly.

• Add vim caret-motion bindings in NORMAL mode (w/W/b/B/e/E/0/$/G/%/f/F/t/T, a/A)
• Expand UI coverage for motions/operators/text objects and add :version command test
• Add :version/:ver command to show version and git hash

Closes #84.