v1.70.0

What's Changed

• [feat] Add option to prefetch completion metadata and to persist completion metadata when switching schemas (#109) by @scottnemes in #1857
• Prepare changelog for release v1.70.0 by @rolandwalker in #1858

Full Changelog: v1.69.0...v1.70.0

v1.69.0

What's Changed

• Make LLM timings use the same format as others by @rolandwalker in #1850
• Bump astral-sh/setup-uv from 8.0.0 to 8.1.0 by @dependabot[bot] in #1851
• Break [colors] into logical groups in myclirc by @rolandwalker in #1852
• Remove non-working Jupyter magic.py by @rolandwalker in #1854
• More control over verbosity levels by @rolandwalker in #1855
• Skip --checkpoint file statements with --resume by @rolandwalker in #1853
• Prepare changelog for release v1.69.0 by @rolandwalker in #1856

Full Changelog: v1.68.1...v1.69.0

v1.68.1

What's Changed

• Upgrade sqlglot to v30.4.3 by @rolandwalker in #1848
• Prepare changelog for release v1.68.1 by @rolandwalker in #1849

Full Changelog: v1.68.0...v1.68.1

v1.68.0

What's Changed

• Add "environment variables" section to TIPS by @rolandwalker in #1749
• Expand keystrokes section in TIPS by @rolandwalker in #1750
• Add a simple AGENTS.md by @rolandwalker in #1751
• Bump astral-sh/setup-uv from 7.6.0 to 8.0.0 by @dependabot[bot] in #1755
• Break sqlcompleter.py find_matches() into units, and add test coverage. by @rolandwalker in #1754
• Make --progress and --checkpoint strictly by-statement by @rolandwalker in #1753
• Add unit tests for mycli/packages/special/utils.py by @rolandwalker in #1757
• Add test coverage for string_utils.py by @rolandwalker in #1756
• Add more tests for parseutils.py by @rolandwalker in #1758
• Test invalid SQL in --batch input by @rolandwalker in #1759
• Remove unused __iter__, which was not returning an iterator by @rolandwalker in #1760
• Put "Codex Review" header in PR review text by @rolandwalker in #1762
• Better formatting for Codex PR reviews, fixing a literal \n\n by @rolandwalker in #1763
• Fix issue stripping multi-character delimiters by @rolandwalker in #1765
• Add more caches to .gitignore by @rolandwalker in #1767
• Continue renaming "toolkit" to "ptoolkit" by @rolandwalker in #1764
• Enhance SQLExecute test coverage by @rolandwalker in #1768
• Add test coverage for mycli/key_bindings.py by @rolandwalker in #1771
• Expand test coverage for special iocommands by @rolandwalker in #1772
• Add tests for --checkup mode by @rolandwalker in #1773
• Expand test coverage for hybrid redirection by @rolandwalker in #1774
• Add tests for special/dbcommands.py by @rolandwalker in #1775
• Add tests for configuration reading by @rolandwalker in #1776
• Extend tests for SQLCompleter by @rolandwalker in #1777
• Extend test coverage for special/llm.py by @rolandwalker in #1778
• Add tests for packages/ptoolkit/fzf.py by @rolandwalker in #1779
• Update changelog with some minor bugfixes by @rolandwalker in #1781
• Add tests for mycli/packages/special/main.py by @rolandwalker in #1780
• Allow sqlexecute tests to run in isolation by @rolandwalker in #1782
• Run pytest suite in random order by @rolandwalker in #1783
• Add tests for clistyle.py by @rolandwalker in #1784
• Add tests for completion_refresher.py by @rolandwalker in #1785
• Add tests for prompt_toolkit history extension by @rolandwalker in #1786
• Add more tests for prompt_utils.py by @rolandwalker in #1788
• Upgrade the llm library to v0.30.0 by @rolandwalker in #1787
• Refactor completion suggestions engine to use declarative rules by @rolandwalker in #1761
• Move --batch branches out of main.py by @rolandwalker in #1769
• Improve refresh/reset completions checks by @rolandwalker in #1770
• Add many regression tests for main.py by @rolandwalker in #1789
• Sort coverage report in tox suite by @rolandwalker in #1790
• Add test coverage for mycli/packages/filepaths.py by @rolandwalker in #1791
• Add tests for mycli/packages/shortcuts.py by @rolandwalker in #1792
• Add more tests for SQLExecute by @rolandwalker in #1793
• Add tests for mycli/clibuffer.py by @rolandwalker in #1794
• Add tests for mycli/packages/ptoolkit/utils.py by @rolandwalker in #1795
• Add tests for mycli/packages/special/favoritequeries.py by @rolandwalker in #1796
• Increase test coverage for parseutils.py by @rolandwalker in #1797
• Add a SQLCompleter test re: fuzzy duplicates by @rolandwalker in #1798
• Add more completion_engine tests by @rolandwalker in #1799
• Add tests for SQLResult by @rolandwalker in #1801
• Add more tests for clitoolbar.py by @rolandwalker in #1800
• Add more tests for delimitercommand.py by @rolandwalker in #1802
• Add a test for batch_utils.py by @rolandwalker in #1803
• Add missing @dbtest test-skip rules by @rolandwalker in #1804
• Move --checkup logic to the new main_modes directory by @rolandwalker in #1805
• Add some style notes to AGENTS.md by @rolandwalker in #1811
• Move --execute code path out of main.py by @rolandwalker in #1807
• Exit with error when the --batch argument is an empty string by @rolandwalker in #1808
• Allow more characters in passwords read from file by @rolandwalker in #1806
• Move --list-dsn execution path out of main.py by @rolandwalker in #1809
• Move --list-ssh-config out of main.py by @rolandwalker in #1810
• Move SQL utilities to sql_utils.py by @rolandwalker in #1812
• Move filtered_sys_argv() to new cli_utils.py by @rolandwalker in #1813
• Create key_binding_utils.py and migrate functions to it by @rolandwalker in #1814
• Improve ssh_utils.py test coverage by @rolandwalker in #1815
• Move REPL execution paths to main_modes/repl.py by @rolandwalker in #1817
• Move complete_while_typing_filter() to repl.py by @rolandwalker in #1818
• Rename MyCli prompt_app property to prompt_session by @rolandwalker in #1819
• Move prompt-format methods to main_modes/repl.py by @rolandwalker in #1821
• Avoid logging SSH passwords by @rolandwalker in #1816
• Remove REPL tests from main_regression.py by @rolandwalker in #1822
• Modernize orthography of prompt_toolkit filters by @rolandwalker in #1827
• Show contributors and sponsors separately in startup messages by @rolandwalker in #1826
• Make null string config test more robust by @rolandwalker in #1824
• Restore full main.py test coverage by @rolandwalker in #1823
• Rename prompt_utils.py to interactive_utils.py by @rolandwalker in #1825
• Bump pypa/gh-action-pypi-publish from 1.13.0 to 1.14.0 by @dependabot[bot] in #1828
• Update and pin Codex GitHub Actions by @rolandwalker in #1831
• Omit deprecated file from test coverage stats by @rolandwalker in #1833
• Feat/440/add sandbox mode by @scottnemes in #1829
• Move show_warnings from main.py to special/iocommands.py by @rolandwalker in #1834
• Improve startup banner/tips test coverage by @rolandwalker in #1836
• Add SQLExecute sandbox test coverage by @rolandwalker in #1837
• Add REPL sandbox mode test coverage by @rolandwalker in #1838
• Improve main.py sandbox-mode test coverage by @rolandwalker in #1839
• Remove unused method get_completions() from main.py by @rolandwalker in #1840
• Configurable balanced-bracket highlight colors by @rolandwalker in #1832
• Bump actions/upload-artifact from 7.0.0 to 7.0.1 by @dependabot[bot] in #1844
• Bump astral-sh/ruff-action from 3.6.1 to 4.0.0 by @dependabot[bot] in #1845
• Don't persist password-change SQL statements to the history file by @rolandwalker in #1835
• Prepare changelog for release v1.68.0 by @rolandwalker in #1846

Full Changelog: v1.67.1...v1.68.0

v1.67.1

What's Changed

• Prepare changelog for release v1.67.1 by @rolandwalker in #1748

Full Changelog: v1.67.0...v1.67.1

v1.67.0

What's Changed

• Display password metavar value as TEXT, not STRING by @rolandwalker in #1734
• Return helpdoc for single -h by @rolandwalker in #1733
• Collect CLI arguments into a dataclass by @rolandwalker in #1732
• --throttle should take a float, not an int by @rolandwalker in #1736
• Respect --no-show-warnings by @rolandwalker in #1737
• Clean up dotfile created by test runs by @rolandwalker in #1740
• Migrate toplevel tool configs to pyproject.toml by @rolandwalker in #1741
• Gather pytest files in a subdirectory by @rolandwalker in #1739
• Refactor: rename "toolkit" to "ptoolkit" by @rolandwalker in #1738
• Ignore recent file moves in git-blame by @rolandwalker in #1742
• Migrate .coveragerc to pyproject.toml section by @rolandwalker in #1743
• Allow --hostname as an alias for --host by @rolandwalker in #1735
• Move screenshots directory to docs directory by @rolandwalker in #1746
• Deprecate DSN environment variable in favor of MYSQL_DSN by @rolandwalker in #1745
• [feat] Suggest related tables with foreign key relationships for JOIN and ON (#975) by @scottnemes in #1747
• Add a --progress progress-bar option by @rolandwalker in #1731

Full Changelog: v1.66.0...v1.67.0

v1.66.0

What's Changed

• Security: Harden codex-review workflow against script injection by @abhayclasher in #1728
• Add --batch option as an alternative to STDIN by @rolandwalker in #1723
• Handle Click exceptions by hand by @rolandwalker in #1714
• Revert suppression of sqlglotrs warnings by @rolandwalker in #1718
• Deprecate $MYSQL_UNIX_PORT environment variable by @rolandwalker in #1720
• Give toolbar tests the sqlexecute property by @rolandwalker in #1722
• Support --username and environment variable to set username by @rolandwalker in #1721
• Update cli_helpers to v2.12.0 by @rolandwalker in #1729
• Prepare changelog for release v1.66.0 by @rolandwalker in #1730

New Contributors

• @abhayclasher made their first contribution in #1728

Full Changelog: v1.65.1...v1.66.0

v1.65.1

What's Changed

• Upgrade sqlglot to v30.0.0 by @rolandwalker in #1715
• Bump astral-sh/setup-uv from 7.5.0 to 7.6.0 by @dependabot[bot] in #1719
• Add OpenAI to list of sponsors by @rolandwalker in #1725
• Prepare changelog for release v1.65.1 by @rolandwalker in #1727

Full Changelog: v1.65.0...v1.65.1

v1.65.0

What's Changed

• Prompt format string for literal backslash by @rolandwalker in #1709
• Suppress warnings when sqlglotrs is installed by @rolandwalker in #1710
• Add collation completions and more charset completions by @rolandwalker in #1711
• Extend the parser's list of binary operators by @rolandwalker in #1712
• Prepare changelog for release v1.65.0 by @rolandwalker in #1713

Full Changelog: v1.64.0...v1.65.0

v1.64.0

What's Changed

• Bump astral-sh/setup-uv from 7.4.0 to 7.5.0 by @dependabot[bot] in #1705
• Add -r option for raw system commands by @rolandwalker in #1704
• Add a dependencies section to --checkup by @rolandwalker in #1700
• Require sqlglot 29.x with C extensions by @rolandwalker in #1707
• Prepare changelog for release v1.64.0 by @rolandwalker in #1708

Full Changelog: v1.63.0...v1.64.0