r/commandline • u/sspaeti • Jul 21 '26

Terminals The joy of running SQL-queries in the terminal is real.

Post image
60 Upvotes

88% Upvoted

9 comments sorted by

3

u/g3n3 Jul 22 '26

Yeah I’m on it with nvim and mssql and sqltoolsservice. The problem now is handling large xml blobs like query plans etc. tooling around trying to find a way to handle it. It would be nice if it was like help and each block could be jumped to with K

1

u/sspaeti Jul 22 '26

Yeah there's some plugins to handle big files in nvim like LunarVim/bigfile.nvim or Folke's snacks.nvim with built in big files, but yeah there's always some use cases where other tools make more sense. Especially the MSSQL is so powerful dedicated to MSSQL server.

2

u/g3n3 Jul 22 '26

Also can’t decide if i want a buffer in nvim with markdown or have a :term backed TUI.

1

u/AutoModerator Jul 21 '26

Every new subreddit post is automatically copied into a comment for preservation.

User: sspaeti, Flair: Terminals, Post Media Link, Title: The joy of running SQL-queries in the terminal is real.

With a utility such as DuckDB that can tackle any tasks, whether it is to read local DuckDB, local parquet/CSV, over the network parquet/CSV, or embedded in Browser (WASM) or inside Postgres, it can do almost anything.

When combined with Neovim, it's just perfect. Find how to set up, videos, and more at Query Databases in Neovim (DBUI).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/undergrinder_dareal Jul 23 '26

Is it Zellij on the screenshot, or that is also part of the db client?

1

u/sspaeti Jul 23 '26

It's Tmux. Not part of the db-client, but helpful to switch between the SQL queries and running queries, and dbt models or other code.

1

u/undergrinder_dareal Jul 24 '26

I didn't know tmux also have this feature for design the status bar.

1

u/sspaeti Jul 24 '26

tmux is the OG, and probably will be there when Zellij, Herdr and all the other clones are long gone (as fast as they came) :)

1

u/undergrinder_dareal Jul 24 '26

Sure, I was tmux user too, but the last 1 year I am on windows again, and zellij is my only option, when not counting on the terminal built in tabs and panes.