Loading video...

Video Failed to Load

There was a problem loading this video. This could be due to a temporary network issue or the video might be unavailable.

sqlit is a lazygit style SQL TUI for the terminal. It supports 10+ databases (Postgres, SQLite, Supabase, ClickHouse, DuckDB, etc), has query history, autocomplete and more. Peter Adams (Maxteabag on GitHub) made sqlit using textualize.io and is Terminal Tool of the Week! ⭐️

Terminal Trove

5,823 subscribers

138,230 views • 10 months ago •via X (Twitter)

Gaming Science & Technology

Anya Rossi• Live Now

Private livecam show

32 Comments

un gato10 months ago

@textualizeio All good until you see it's written/distributed with python. Nothing against python, but nowadays for TUIs is either go or rust, and distributed as a single binary.

Just Chris 👤 priv/acc10 months ago

@textualizeio Python??? Whyyy. Binaries guys. Binaries.

Carlo Taleon10 months ago

@textualizeio I very much like this. How is it compared to

0x_0w510 months ago

@textualizeio Completely lost interest when I discovered it's made with Python instead of Rust.

Mau10 months ago

@textualizeio If this was vibe coded why chosing an intérpreted lenguaje. Use rust man!!

J E D10 months ago

@textualizeio this is pretty cool!

Terminal Trove10 months ago

we had fun trying this one out, shout out to @max_tbag for building sqlit!

Nuno10 months ago

@textualizeio ``` "~/.local/pipx/venvs/sqlit/lib/python3.12/site-packages/sqlit/main.py", line 125 print sql ^^^^^^^^^ ... Is this suppose to run with python 2? Debug issues?

Anthony Rende 🌕10 months ago

@textualizeio 2026 year of the TUI

Micha(el) Bladowski 🇩🇪 🇺🇦10 months ago

@textualizeio Glad you didn't post a link, so nobody accidentally gets there 👍

koushik10 months ago

@textualizeio everything looks better in a tui

Sergey Kuleshov10 months ago

@textualizeio Does it support editing records?

Greg Konush (｡◕‿◕｡)10 months ago

@textualizeio drop bobby tables

Nabin Saud10 months ago

@textualizeio Amazing right now using tsql will give a try

Karan Jagtiani10 months ago

@textualizeio TUI is pretty handy for database work. What specific features stand out for you?

Kamen10 months ago

@textualizeio BROOOOOOO so cool!

Kehinde10 months ago

@textualizeio this looks fun. Will try it out for turso.

Saïd Aitmbarek10 months ago

@textualizeio based share!

Matt Ferrante10 months ago

@textualizeio

Amadi10 months ago

@textualizeio Great project, but this is such a terrible name to Google

Elan Vital10 months ago

@textualizeio Ohhhh, I was to found like this

mox 🐀10 months ago

@textualizeio Any similar TUI tools for Redis?

jew' nna tools ❌10 months ago

@textualizeio written in golang, and better:

AK10 months ago

@textualizeio terminal UIs >> web dashboards for dev work. at Cozmo we're building CLI tools for FSI agent deployment. speed + keyboard shortcuts = productivity. sqlit looks clean

Peter Adams10 months ago

@textualizeio Thanks for the feature! 🙏

davydotcom10 months ago

@textualizeio @OmarchyLinux

Sanskar Bhushan10 months ago

@textualizeio cool!!!

Alade Yessoufou10 months ago

@textualizeio TUI ?

Hank Costello10 months ago

@textualizeio Lit!

Thanh Doan10 months ago

@textualizeio it's super cool, but i wonder how often i'd reach for a tui over something like datagrip for serious sql work

Darin10 months ago

@textualizeio I've used pgcli. I'll give Sqlit a try

Bohu10 months ago

@textualizeio Cool, it would be great to support Databend ( The driver is here:

Related Videos

nless is a TUI tool that is like Excel for live log data. It takes in logs, CSV or JSON and transforms them into columns in the terminal. You can then filter, sort, search, stream live data and more. Matt Pryor (mpryor on GitHub) made nless using textualize.io and is Terminal Tool of the Week! ⭐️

nless is a TUI tool that is like Excel for live log data. It takes in logs, CSV or JSON and transforms them into columns in the terminal. You can then filter, sort, search, stream live data and more. Matt Pryor (mpryor on GitHub) made nless using textualize.io and is Terminal Tool of the Week! ⭐️

Terminal Trove

32,195 views • 5 months ago

wrkflw is a CLI and TUI tool for testing and running CI jobs locally. You can validate GitHub / GitLab CI workflows, run jobs, watch logs, manage secrets, use Docker, Podman runtimes and more. @bahdotshx made wrkflw using Ratatui and is Terminal Tool of the Week! ⭐️

wrkflw is a CLI and TUI tool for testing and running CI jobs locally. You can validate GitHub / GitLab CI workflows, run jobs, watch logs, manage secrets, use Docker, Podman runtimes and more. @bahdotshx made wrkflw using Ratatui and is Terminal Tool of the Week! ⭐️

Terminal Trove

17,193 views • 5 months ago

netwatch is an all in one network diagnostics tool that monitors connections in real time. It has a live traffic timeline, ASCII network map, latency heat-maps and more. Matt Hartley (matthart1983 on GitHub) made netwatch using Ratatui and is Terminal Tool of the Week! ⭐️

netwatch is an all in one network diagnostics tool that monitors connections in real time. It has a live traffic timeline, ASCII network map, latency heat-maps and more. Matt Hartley (matthart1983 on GitHub) made netwatch using Ratatui and is Terminal Tool of the Week! ⭐️

Terminal Trove

113,418 views • 6 months ago

GPT-5.6-Sol-Ultra built a Doom-like game in SQL: the game is running in the terminal on the left, while the SQL powering the game in the terminal on the right. How it works: DOOMQL is a game engine implemented in 2,000+ lines of SQL. Every frame, SQL raycasts the scene, calculates every RGB pixel, and encodes those pixels as coloured terminal characters. The same SQL then handles controls, movement, collision, enemy AI and combat, while Python connects SQLite to the keyboard, clock and terminal.

GPT-5.6-Sol-Ultra built a Doom-like game in SQL: the game is running in the terminal on the left, while the SQL powering the game in the terminal on the right. How it works: DOOMQL is a game engine implemented in 2,000+ lines of SQL. Every frame, SQL raycasts the scene, calculates every RGB pixel, and encodes those pixels as coloured terminal characters. The same SQL then handles controls, movement, collision, enemy AI and combat, while Python connects SQLite to the keyboard, clock and terminal.

Peter Gostev

122,407 views • 3 months ago

🚀 Launched today 2.0 🐘 Modern Postgres Terminal. Fast. Native. Written in Rust. Everything you already had in the shell - now with a native TUI and PgBot built in. → SQL - write queries and inspect results → Data - browse schemas, tables and rows → Branches - create and switch Postgres branches → PgBot - ask questions about your database → Mouse support - hover, inspect, click And yes - the SQL safety model is built in, because once agents start touching databases, it matters. No Electron. →

🚀 Launched today 2.0 🐘 Modern Postgres Terminal. Fast. Native. Written in Rust. Everything you already had in the shell - now with a native TUI and PgBot built in. → SQL - write queries and inspect results → Data - browse schemas, tables and rows → Branches - create and switch Postgres branches → PgBot - ask questions about your database → Mouse support - hover, inspect, click And yes - the SQL safety model is built in, because once agents start touching databases, it matters. No Electron. →

alex shapalov

66,979 views • 1 month ago

Let Postgres own the Iceberg catalog and delegate analytics to DuckDB. The result => transactional lakehouse updates with fast analytical queries. This isn’t a concept. It’s exactly what pg_lake delivers today. pg_lake combines a set of extensions and components that let you query and modify Iceberg tables (and other lakehouse formats) directly from Postgres. DuckDB is used to accelerate analytical queries and runs in a sidecar process called pgduck_server, which communicates with Postgres during query execution. How it works (diagram below): 1. An application sends a query to Postgres to calculate unrealized PnL (Profit and Loss) for the Disney ticker. 2. Postgres parses the query and identifies the part that computes the average price from historical lakehouse data. 3. That part is forwarded to pgduck_server for accelerated execution. 4. pgduck_server delegates execution to DuckDB, which queries the lakehouse (reusing cached data if available). 5. DuckDB computes the average price and returns it to Postgres. 6. Postgres joins the result with local portfolio data and computes the unrealized PnL. 7. The final result is returned to the application.

Let Postgres own the Iceberg catalog and delegate analytics to DuckDB. The result => transactional lakehouse updates with fast analytical queries. This isn’t a concept. It’s exactly what pg_lake delivers today. pg_lake combines a set of extensions and components that let you query and modify Iceberg tables (and other lakehouse formats) directly from Postgres. DuckDB is used to accelerate analytical queries and runs in a sidecar process called pgduck_server, which communicates with Postgres during query execution. How it works (diagram below): 1. An application sends a query to Postgres to calculate unrealized PnL (Profit and Loss) for the Disney ticker. 2. Postgres parses the query and identifies the part that computes the average price from historical lakehouse data. 3. That part is forwarded to pgduck_server for accelerated execution. 4. pgduck_server delegates execution to DuckDB, which queries the lakehouse (reusing cached data if available). 5. DuckDB computes the average price and returns it to Postgres. 6. Postgres joins the result with local portfolio data and computes the unrealized PnL. 7. The final result is returned to the application.

Denis Magda

28,597 views • 8 months ago

$Google open-sourced MCP Toolbox for Databases. I gave it access to everything else. For context, Google's MCP Toolbox for Databases is an open-source server that lets AI agents securely query structured databases like PostgreSQL and MySQL through the MCP protocol However, most enterprise knowledge doesn't actually live in databases. It's scattered across emails, Slack threads, GitHub repos, Salesforce records, customer reviews, and internal docs. So Agents can't see any of it, which means they're working with a fraction of the context they need. I fixed that using MindsDB. It acts as a universal SQL layer that sits on top of all your data sources: structured, semi-structured, and unstructured. This means you can query Salesforce, Gmail, GitHub, S3 files, Jira, and 200+ more sources using SQL syntax. The clever part is how it connects to the MCP Toolbox. MindsDB exposes everything through MySQL, so from the Agent's perspective, it's just running SQL and getting context back. It doesn't know or care that the data came from five different sources behind the scenes. This setup unlocks some powerful capabilities: → One SQL interface for dozens of enterprise sources → Cross-datasource joins (combine GitHub and CRM data in a single query) → Built-in ML capabilities for working with unstructured data → Simple MCP tools that now have massively expanded reach In the video below, the Agent queries GitHub data and a customer review database in one SQL query. So what used to require ETL pipelines and weeks of engineering effort now happens instantly. At the end of the day, AI agents are only as useful as the data they can access. This gives them a lot more to work with. I have shared the GitHub repo in the replies, where you can find more details about this.$

Google open-sourced MCP Toolbox for Databases. I gave it access to everything else. For context, Google's MCP Toolbox for Databases is an open-source server that lets AI agents securely query structured databases like PostgreSQL and MySQL through the MCP protocol However, most enterprise knowledge doesn't actually live in databases. It's scattered across emails, Slack threads, GitHub repos, Salesforce records, customer reviews, and internal docs. So Agents can't see any of it, which means they're working with a fraction of the context they need. I fixed that using MindsDB. It acts as a universal SQL layer that sits on top of all your data sources: structured, semi-structured, and unstructured. This means you can query Salesforce, Gmail, GitHub, S3 files, Jira, and 200+ more sources using SQL syntax. The clever part is how it connects to the MCP Toolbox. MindsDB exposes everything through MySQL, so from the Agent's perspective, it's just running SQL and getting context back. It doesn't know or care that the data came from five different sources behind the scenes. This setup unlocks some powerful capabilities: → One SQL interface for dozens of enterprise sources → Cross-datasource joins (combine GitHub and CRM data in a single query) → Built-in ML capabilities for working with unstructured data → Simple MCP tools that now have massively expanded reach In the video below, the Agent queries GitHub data and a customer review database in one SQL query. So what used to require ETL pipelines and weeks of engineering effort now happens instantly. At the end of the day, AI agents are only as useful as the data they can access. This gives them a lot more to work with. I have shared the GitHub repo in the replies, where you can find more details about this.

Akshay 🚀

40,562 views • 8 months ago

⚡️ Open SQLite Databases in React Native Debugging SQLite was always challenging until I found out about this library: Drizzle Studio for Expo SQLite 🎉 This is a dev tool plugin you can easily install in your app and open by pressing shift + m in your terminal. The result is the easiest way to see and edit your SQLite data right inside your browser 😍 Did you know about this plugin??

⚡️ Open SQLite Databases in React Native Debugging SQLite was always challenging until I found out about this library: Drizzle Studio for Expo SQLite 🎉 This is a dev tool plugin you can easily install in your app and open by pressing shift + m in your terminal. The result is the easiest way to see and edit your SQLite data right inside your browser 😍 Did you know about this plugin??

Simon Grimm

16,351 views • 2 years ago

Special treat for the Andy Pavlo (@andypavlo.bsky.social) fans out there: an in-depth discussion about what happens to databases when billions of AI agents hit them, his move to build a research lab at ClickHouse, and plently of hot takes on the database market (Postgres, vector, graph, GPU etc) 00:00 Cold open & Intro 01:21 From vector databases and RAG to the age of agents 04:09 Neon's stat: agents create 80% of databases? 07:25 Why agents keep deleting production databases 08:19 Guardrails: the toddler-and-stairs rule 10:51 The four eras of database volume: 10–100x more queries 15:10 Agent memory: files vs. databases ("everything is a database") 18:24 Which database do AI models recommend? 19:25 "It cites me back to myself" 23:14 MCP for databases, and text-to-SQL from 60% to 99.5% 27:09 Trust an agent the way you'd trust a junior developer 27:47 Can AI build an entire database? Opus 4 and the CMU projects 29:57 60% of open-source databases now have AI commits 30:43 Ten years of self-driving databases, Peloton to today 33:52 What LLMs changed: 85% of the tuning in 15 minutes 35:42 Should anyone still study databases? 38:27 Free CMU courses, the DJ, and the Wu-Tang final exam 42:09 Why start a research lab inside ClickHouse? 45:53 Why ClickHouse looked like vaporware in 2016 47:46 What makes ClickHouse fast: columns, vectors, Snowflake's lineage 52:22 Why Databricks, Snowflake and ClickHouse all added Postgres 58:15 Vector, graph and GPU databases: thumbs up or down? 1:08:34 Is the database market stagnant? "A cheetah on cocaine in a Ferrari" 1:10:14 The relational model is arithmetic; SQL as the new assembly 1:11:59 Larry Ellison, Linux, and why databases still matter

Special treat for the Andy Pavlo (@andypavlo.bsky.social) fans out there: an in-depth discussion about what happens to databases when billions of AI agents hit them, his move to build a research lab at ClickHouse, and plently of hot takes on the database market (Postgres, vector, graph, GPU etc) 00:00 Cold open & Intro 01:21 From vector databases and RAG to the age of agents 04:09 Neon's stat: agents create 80% of databases? 07:25 Why agents keep deleting production databases 08:19 Guardrails: the toddler-and-stairs rule 10:51 The four eras of database volume: 10–100x more queries 15:10 Agent memory: files vs. databases ("everything is a database") 18:24 Which database do AI models recommend? 19:25 "It cites me back to myself" 23:14 MCP for databases, and text-to-SQL from 60% to 99.5% 27:09 Trust an agent the way you'd trust a junior developer 27:47 Can AI build an entire database? Opus 4 and the CMU projects 29:57 60% of open-source databases now have AI commits 30:43 Ten years of self-driving databases, Peloton to today 33:52 What LLMs changed: 85% of the tuning in 15 minutes 35:42 Should anyone still study databases? 38:27 Free CMU courses, the DJ, and the Wu-Tang final exam 42:09 Why start a research lab inside ClickHouse? 45:53 Why ClickHouse looked like vaporware in 2016 47:46 What makes ClickHouse fast: columns, vectors, Snowflake's lineage 52:22 Why Databricks, Snowflake and ClickHouse all added Postgres 58:15 Vector, graph and GPU databases: thumbs up or down? 1:08:34 Is the database market stagnant? "A cheetah on cocaine in a Ferrari" 1:10:14 The relational model is arithmetic; SQL as the new assembly 1:11:59 Larry Ellison, Linux, and why databases still matter

Matt Turck

20,079 views • 15 days ago

Supabase RLS tester is here! You can run a query as another user and see which RLS policy took effect! It also supports testing queries via client libraries, with AI converting them to SQL. Enable it today from the feature preview section on the dashboard!

Supabase RLS tester is here! You can run a query as another user and see which RLS policy took effect! It also supports testing queries via client libraries, with AI converting them to SQL. Enable it today from the feature preview section on the dashboard!

Tyler Shukert

16,336 views • 5 months ago

The massive construction going on at the MMIA is one of Nigerias most audacious project in its history! Even the temporary terminal is alot more beautiful than the old terminal we had.. Watch and send some prayers for PBAT

The massive construction going on at the MMIA is one of Nigerias most audacious project in its history! Even the temporary terminal is alot more beautiful than the old terminal we had.. Watch and send some prayers for PBAT

Comrade Àmọdá 🦇

79,090 views • 4 months ago

When the cost of error is high, trust is everything. Dan, a director of Senior Corporate Counsel at GitHub, used GitHub Copilot CLI to build a custom skill that embeds inline screenshots of source documents to verify AI analysis. Dan's tool, aptly named Eyeball, helps the legal team check complex clauses and act on AI outputs with confidence. Now, every lawyer at GitHub is using the terminal to streamline their daily workflows. ▶️

When the cost of error is high, trust is everything. Dan, a director of Senior Corporate Counsel at GitHub, used GitHub Copilot CLI to build a custom skill that embeds inline screenshots of source documents to verify AI analysis. Dan's tool, aptly named Eyeball, helps the legal team check complex clauses and act on AI outputs with confidence. Now, every lawyer at GitHub is using the terminal to streamline their daily workflows. ▶️

GitHub

87,960 views • 1 month ago

The wait is over. Dynamic Terminal is now live on Meteora. Featuring a trading-terminal inspired layout, important pool & token insights, precise min/max range controls, charting tools, quick LP actions, and much more. Explore the upgrade and experience the new Dynamic Terminal for DLMM on Meteora.

The wait is over. Dynamic Terminal is now live on Meteora. Featuring a trading-terminal inspired layout, important pool & token insights, precise min/max range controls, charting tools, quick LP actions, and much more. Explore the upgrade and experience the new Dynamic Terminal for DLMM on Meteora.

Meteora

126,421 views • 7 months ago

First of its kind? New feature in Ghostty: a web-inspector-style "terminal inspector" targeted at CLI, TUI developers. Built right into the terminal, you can see a live view of terminal state, keyboard events, escape sequences, and much much more. 👻💖 Video tour below. Similar to Firebug with Firefox, I'm hoping this helps usher in a new era of develop-ability for terminal applications by making it much much easier to understand what is going on. When the inspector is not in use, there is no perceivable performance impact (benchmarks show the same). When the inspector is in use, the terminal it is inspecting slows down to about half speed due to the overhead. But this only impacts the terminal being inspected. This is a really early version of the inspector. The data organization is kind of messy, its mostly read-only information right now, and there is a lot more information I want to surface. The next step is making a lot of this data read-write so you can actually modify the terminal live (similar to modifying HTML/CSS live in a web inspector) to trial-and-error some changes. This is just the beginning. 😎 Follow along Ghostty development here:

First of its kind? New feature in Ghostty: a web-inspector-style "terminal inspector" targeted at CLI, TUI developers. Built right into the terminal, you can see a live view of terminal state, keyboard events, escape sequences, and much much more. 👻💖 Video tour below. Similar to Firebug with Firefox, I'm hoping this helps usher in a new era of develop-ability for terminal applications by making it much much easier to understand what is going on. When the inspector is not in use, there is no perceivable performance impact (benchmarks show the same). When the inspector is in use, the terminal it is inspecting slows down to about half speed due to the overhead. But this only impacts the terminal being inspected. This is a really early version of the inspector. The data organization is kind of messy, its mostly read-only information right now, and there is a lot more information I want to surface. The next step is making a lot of this data read-write so you can actually modify the terminal live (similar to modifying HTML/CSS live in a web inspector) to trial-and-error some changes. This is just the beginning. 😎 Follow along Ghostty development here:

Mitchell Hashimoto

96,303 views • 3 years ago

I love Aether, but I love the terminal even more. Here's Peachy. Omarchy is the first-class citizen for theming. However, it has full support for all kinds of distros. It even supports macOS. Started playing Arc Raiders during the Holidays, so a new theme had to be made.

I love Aether, but I love the terminal even more. Here's Peachy. Omarchy is the first-class citizen for theming. However, it has full support for all kinds of distros. It even supports macOS. Started playing Arc Raiders during the Holidays, so a new theme had to be made.

Bjarne Øverli

95,096 views • 9 months ago

An open-source alternative to Palantir Foundry is here. And it looks seriously exciting! Meet Helix Foundry! It connects your databases, APIs, files, and services like Stripe into a company ontology: a graph linking customers, transactions, users, and other business entities. You can query it, explore those relationships, and ask questions using AI, with answers backed by executed SQL. Under the hood: → HelixDB stores the ontology → S3-compatible storage holds data snapshots → DuckDB transforms and analyzes the data Very excited to see this kind of tooling go open source. Repo link in 🧵↓

An open-source alternative to Palantir Foundry is here. And it looks seriously exciting! Meet Helix Foundry! It connects your databases, APIs, files, and services like Stripe into a company ontology: a graph linking customers, transactions, users, and other business entities. You can query it, explore those relationships, and ask questions using AI, with answers backed by executed SQL. Under the hood: → HelixDB stores the ontology → S3-compatible storage holds data snapshots → DuckDB transforms and analyzes the data Very excited to see this kind of tooling go open source. Repo link in 🧵↓

Charly Wargnier ♨️

34,617 views • 13 days ago