https://github.com/tconbeer/harlequin Skip to content Toggle navigation Sign in * Product + Actions Automate any workflow + Packages Host and manage packages + Security Find and fix vulnerabilities + Codespaces Instant dev environments + Copilot Write better code with AI + Code review Manage code changes + Issues Plan and track work + Discussions Collaborate outside of code Explore + All features + Documentation + GitHub Skills + Blog * Solutions For + Enterprise + Teams + Startups + Education By Solution + CI/CD & Automation + DevOps + DevSecOps Resources + Learning Pathways + White papers, Ebooks, Webinars + Customer Stories + Partners * Open Source + GitHub Sponsors Fund open source developers + The ReadME Project GitHub community articles Repositories + Topics + Trending + Collections * Pricing Search or jump to... Search code, repositories, users, issues, pull requests... Search [ ] Clear Search syntax tips Provide feedback We read every piece of feedback, and take your input very seriously. [ ] [ ] Include my email address so I can be contacted Cancel Submit feedback Saved searches Use saved searches to filter your results more quickly Name [ ] Query [ ] To see all available qualifiers, see our documentation. Cancel Create saved search Sign in Sign up You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert {{ message }} tconbeer / harlequin Public * Notifications * Fork 18 * Star 872 The SQL IDE for Your Terminal. harlequin.sh License MIT license 872 stars 18 forks Activity Star Notifications * Code * Issues 24 * Pull requests 7 * Discussions * Actions * Security * Insights Additional navigation options * Code * Issues * Pull requests * Discussions * Actions * Security * Insights tconbeer/harlequin This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. main Switch branches/tags [ ] Branches Tags Could not load branches Nothing to show {{ refName }} default View all branches Could not load tags Nothing to show {{ refName }} default View all tags Name already in use A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch? Cancel Create 134 branches 45 tags Code * Local * Codespaces * Clone HTTPS GitHub CLI [https://github.com/t] Use Git or checkout with SVN using the web URL. [gh repo clone tconbe] Work fast with our official CLI. Learn more about the CLI. * Open with GitHub Desktop * Download ZIP Sign In Required Please sign in to use Codespaces. Launching GitHub Desktop If nothing happens, download GitHub Desktop and try again. Launching GitHub Desktop If nothing happens, download GitHub Desktop and try again. Launching Xcode If nothing happens, download Xcode and try again. Launching Visual Studio Code Your codespace will open once ready. There was a problem preparing your codespace, please try again. Latest commit @TylerHillery @tconbeer TylerHillery and tconbeer Add Trino Adapter ... dfdf48d Dec 27, 2023 Add Trino Adapter dfdf48d Git stats * 215 commits Files Permalink Failed to load latest commit information. Type Name Latest commit message Commit time .github refactor: use messages instead of reactives for query execution (#365 ) December 19, 2023 11:42 src feat: copy data to clipboard December 21, 2023 15:29 static chore: update to all-new TextArea widget (#349) December 7, 2023 13:34 stubs fix: bump fastdatatable to prevent typeerror crash (#266) October 9, 2023 12:51 tests feat: copy data to clipboard December 21, 2023 15:29 .gitattributes feat: autocomplete (#351) December 13, 2023 12:48 .gitignore feat/config (#341) November 30, 2023 14:41 .pre-commit-config.yaml feat: truncate values with tooltip December 21, 2023 15:29 .python-version Support Copy and Paste, Tab (#52) May 15, 2023 12:10 CHANGELOG.md Bumps version to 1.8.0 December 21, 2023 21:33 LICENSE Initial commit May 2, 2023 09:44 Makefile refactor: use messages instead of reactives for query execution (#365 ) December 19, 2023 11:42 README.md feat: autocomplete (#351) December 13, 2023 12:48 harlequin.svg feat: autocomplete (#351) December 13, 2023 12:48 poetry.lock Add Trino Adapter December 26, 2023 18:57 pyproject.toml Add Trino Adapter December 26, 2023 18:57 View code [ ] Harlequin Installing Harlequin Using Harlequin with DuckDB Using Harlequin with SQLite and Other Adapters Getting Help More info at harlequin.sh Contributing Providing Feedback Setting up Your Dev Environment and Running Tests Opening PRs README.md Harlequin PyPI PyPI - Python Version Runs on Linux | MacOS | Windows The SQL IDE for Your Terminal. Harlequin Installing Harlequin After installing Python 3.8 or above, install Harlequin using pip or pipx with: pipx install harlequin Using Harlequin with DuckDB From any shell, to open one or more DuckDB database files: harlequin "path/to/duck.db" "another_duck.db" To open an in-memory DuckDB session, run Harlequin with no arguments: harlequin If you want to control the version of DuckDB that Harlequin uses, see the Troubleshooting page. Using Harlequin with SQLite and Other Adapters Harlequin also ships with a SQLite3 adapter. You can open one or more SQLite database files with: harlequin -a sqlite "path/to/sqlite.db" "another_sqlite.db" Like DuckDB, you can also open an in-memory database by omitting the paths: harlequin -a sqlite Other adapters can be installed using pip install or pipx inject harlequin , depending on how you installed Harlequin. For a list of known adapters provided either by the Harlequin maintainers or the broader community, see the adapters page in the docs. Getting Help To view all command-line options for Harlequin and all installed adapters, after installation, simply type: harlequin --help To view a list of all key bindings (keyboard shortcuts) within the app, press F1. You can also view this list outside the app in the docs. More info at harlequin.sh Visit harlequin.sh for an overview of features and full documentation. Contributing Thanks for your interest in Harlequin! Harlequin is primarily maintained by Ted Conbeer, but he welcomes all contributions and is looking for additional maintainers! Providing Feedback We'd love to hear from you! Open an Issue to request new features, report bugs, or say hello. Setting up Your Dev Environment and Running Tests 1. Install Poetry v1.2 or higher if you don't have it already. You may also need or want pyenv, make, and gcc. 2. Fork this repo, and then clone the fork into a directory (let's call it harlequin), then cd harlequin. 3. Use poetry install --sync to install the project (editable) and its dependencies (including all test and dev dependencies) into a new virtual env. 4. Use poetry shell to spawn a subshell. 5. Type make to run all tests and linters, or run pytest, black ., ruff . --fix, and mypy individually. Opening PRs 1. PRs should be motivated by an open issue. If there isn't already an issue describing the feature or bug, open one. Do this before you write code, so you don't waste time on something that won't get merged. 2. Ideally new features and bug fixes would be tested, to prevent future regressions. Textual provides a test harness that we use to test features of Harlequin. You can find some examples in the tests directory of this project. Please include a test in your PR, but if you can't figure it out, open a PR to ask for help. 3. Open a PR from your fork to the main branch of tconbeer/ harlequin. In the PR description, link to the open issue, and then write a few sentences about why you wrote the code you did: explain your design, etc. 4. Ted may ask you to make changes, or he may make them for you. Don't take this the wrong way -- he values your contributions, but he knows this isn't your job, either, so if it's faster for him, he may push a commit to your branch or create a new branch from your commits. About The SQL IDE for Your Terminal. harlequin.sh Resources Readme License MIT license Activity Stars 872 stars Watchers 8 watching Forks 18 forks Report repository Releases 45 v1.8.0 Latest Dec 22, 2023 + 44 releases Packages 0 No packages published Contributors 8 * @tconbeer * @dependabot[bot] * @github-actions[bot] * @dljsjr * @Mause * @joshtemple * @aaronsteers * @TylerHillery Languages * Python 99.8% * Makefile 0.2% Footer (c) 2024 GitHub, Inc. Footer navigation * Terms * Privacy * Security * Status * Docs * Contact * Manage cookies * Do not share my personal information You can't perform that action at this time.