--- title: LibreDB Studio: a self-hosted SQL IDE that runs in your... description: LibreDB Studio is a self-hosted, browser-based SQL IDE that supports 46 databases including Postgres, MySQL, Oracle, SQL Server, MongoDB, Redis, ClickHouse,... canonical: https://daily.dev/posts/libredb-studio-a-self-hosted-sql-ide-that-runs-in-your-browser-for-46-databases-mbqwcagfw twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: LibreDB Studio: a self-hosted SQL IDE that runs in your browser, for 46 databases | daily.dev og:description: LibreDB Studio is a self-hosted, browser-based SQL IDE that supports 46 databases including Postgres, MySQL, Oracle, SQL Server, MongoDB, Redis, ClickHouse,... og:url: https://daily.dev/posts/libredb-studio-a-self-hosted-sql-ide-that-runs-in-your-browser-for-46-databases-mbqwcagfw og:image: https://api.daily.dev/og/posts/mbqwcAgFW.png og:image:alt: LibreDB Studio: a self-hosted SQL IDE that runs in your browser, for 46 databases og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # LibreDB Studio: a self-hosted SQL IDE that runs in your browser, for 46 databases **[cevheri](https://daily.dev/sources/j6gjfvntm6h4f4hblpc77)** · [@cevheri](https://daily.dev/cevheri) · 1 min read · 40 upvotes · 9 comments ## Summary LibreDB Studio is a self-hosted, browser-based SQL IDE that supports 46 databases including Postgres, MySQL, Oracle, SQL Server, MongoDB, Redis, ClickHouse, DuckDB, and Cassandra. It deploys via Docker or Helm alongside your database, eliminating the need for SSH tunnels or desktop clients on every laptop. The project is MIT licensed and includes SSO support and an AI assistant. The maintainers are soliciting feedback on which database to support next. ## Content Repo: [https://github.com/libredb/libredb-studio](https://github.com/libredb/libredb-studio) Demo: [https://app.libredb.org](https://app.libredb.org) Youtube : [https://www.youtube.com/watch?v=rWANKEDszs4](https://www.youtube.com/watch?v=rWANKEDszs4) Deploy it next to your database with Docker or Helm and open it in the browser. No SSH tunnels, no desktop client on every laptop. Postgres, MySQL, Oracle, SQL Server, MongoDB, Redis, ClickHouse, DuckDB, Cassandra and more. MIT licensed, SSO and the AI assistant included. Which database would you want next? ## Community discussion Top comments from developers on daily.dev. **@cevheri** · 7 upvotes > Some projects that list it in their official docs: > > - PostgreSQL: https://www.postgresql.org/download/products/1 > > - Redis: https://redis.io/docs/latest/develop/tools/#libredb-studio > > - ClickHouse: https://clickhouse.com/docs/integrations/connectors/tools/gui#libredb-studio > > - MariaDB: https://mariadb.com/docs/server/clients-and-utilities/graphical-and-enhanced-clients/libredb-studio > > - DuckDB: https://duckdb.org/docs/preview/guides/sql*editors/libredb*studio > > - Trino: https://trino.io/ecosystem/client-application#libredb-studio > > - YugabyteDB:... **@pdfopsdev** · 1 upvotes > supporting 46 backends through one UI is ambitious, that kind of breadth usually comes at the cost of each driver being shallow. how deep does the mongo/cassandra support actually go vs just basic CRUD? **@cevheri** · 1 upvotes > @hardik15 That is why the grid doesn't load everything at once by default. The query runs on the server side right next to the database and the relevant tab fetches only one page of data: a `SELECT` query without a `LIMIT` clause returns 500 rows, while the "Load More" option retrieves the next 500 rows upon request. Loading the entire dataset requires your confirmation first and stops at 100,000 rows. The grid uses a virtualized structure; therefore, regardless of how many rows are loaded, only those visible on the screen are processed and displayed. > > The loaded rows are kept in the tab's... **@ristotoldsep** · 0 upvotes > 46 databases in one browser tab is both impressive and slightly threatening. **@hardik15** · 0 upvotes > That's a great to start with, or hear at the first place; > > However the biggest worry or issue I can foresee is the memory consumption or lag on production, or even a thousand of rows. > > > Many browser tabs are already memory hungry and people already had a good number of tabs opens, when you open this as well on the tab, it we acquire more and more memory than a stand-alone app unless you use it mainly for schema or very limited rows use cases. > > > I had similar kind of experience in Google Sheets few years before. I had thousands of rows of data in a sheet, initially it is very smooth however as... ## Similar posts on daily.dev - [LibreDB Studio: an open source, self-hosted SQL IDE for PostgreSQL in the browser](https://daily.dev/posts/libredb-studio-an-open-source-self-hosted-sql-ide-for-postgresql-in-the-browser-hamfaprfe) · PostgreSQL · 67 upvotes · 3 comments - [DBngin: Free local database manager for macOS \(no docker\)](https://daily.dev/posts/dbngin-free-local-database-manager-for-macos-no-docker--fh24qjt31) · FireUp · 26 upvotes · 1 comments - [The browser is your database: Local-first comes of age](https://daily.dev/posts/the-browser-is-your-database-local-first-comes-of-age-qpvygfxu9) · InfoWorld · 4 upvotes · 0 comments - [Database Features in Rider](https://daily.dev/posts/database-features-in-rider-06w8u3wvc) · JetBrains · 2 upvotes · 0 comments - [Portabase: A Lightweight Self-Hosted Database Backup Solution](https://daily.dev/posts/portabase-a-lightweight-self-hosted-database-backup-solution-5hnbhzxb9) · Noted · 64 upvotes · 2 comments --- Tags: [#backend](https://daily.dev/tags/backend), [#docker](https://daily.dev/tags/docker), [#sql](https://daily.dev/tags/sql), [#self-hosting](https://daily.dev/tags/self-hosting) [View this post on daily.dev](https://daily.dev/posts/libredb-studio-a-self-hosted-sql-ide-that-runs-in-your-browser-for-46-databases-mbqwcagfw) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"DiscussionForumPosting","mainEntityOfPage":"https://daily.dev/posts/libredb-studio-a-self-hosted-sql-ide-that-runs-in-your-browser-for-46-databases-mbqwcagfw","headline":"LibreDB Studio: a self-hosted SQL IDE that runs in your browser, for 46 databases","text":"LibreDB Studio is a self-hosted, browser-based SQL IDE that supports 46 databases including Postgres, MySQL, Oracle, SQL Server, MongoDB, Redis, ClickHouse, DuckDB, and Cassandra. It deploys via Docker or Helm alongside your database, eliminating the need for SSH tunnels or desktop clients on every laptop. The project is MIT licensed and includes SSO support and an AI assistant. The maintainers are soliciting feedback on which database to support next.","url":"https://daily.dev/posts/libredb-studio-a-self-hosted-sql-ide-that-runs-in-your-browser-for-46-databases-mbqwcagfw","datePublished":"2026-09-30T18:02:56.397Z","dateModified":"2026-09-30T18:03:12.958Z","author":{"@type":"Person","name":"cevheri","url":"https://daily.dev/cevheri","image":"https://avatars.githubusercontent.com/u/12383547?v=4","description":"software engineer","interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"EndorseAction"},"userInteractionCount":830}},"image":"https://media.daily.dev/image/upload/s--77z5Zu87--/f_auto/v1790791376/posts/mbqwcAgFW?_a=BAMAMicg0","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":40},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":9}],"comment":[{"@type":"Comment","text":"Some projects that list it in their official docs:\n\n\nPostgreSQL: https://www.postgresql.org/download/products/1\n\n\nRedis: https://redis.io/docs/latest/develop/tools/#libredb-studio\n\n\nClickHouse: https://clickhouse.com/docs/integrations/connectors/tools/gui#libredb-studio\n\n\nMariaDB: https://mariadb.com/docs/server/clients-and-utilities/graphical-and-enhanced-clients/libredb-studio\n\n\nDuckDB: https://duckdb.org/docs/preview/guides/sql*editors/libredb*studio\n\n\nTrino: https://trino.io/ecosystem/client-application#libredb-studio\n\n\nYugabyteDB: https://docs.yugabyte.com/stable/integrations/tools/libredb-studio/\n\n\nStarRocks: https://docs.starrocks.io/docs/integrations/IDE*integrations/LibreDB*Studio/\n\n\nDragonflyDB: https://www.dragonflydb.io/docs/integrations/libredb-studio\n\n\nOpenSearch: https://opensearch.org/community-projects/\n\n\nApache Cloudberry: https://cloudberry.apache.org/docs/ecosystem/sql-clients/libredb-studio/\n\n\nAiven: https://aiven.io/docs/products/postgresql/howto/connect-libredb-studio","datePublished":"2026-09-30T18:03:11.402Z","url":"https://daily.dev/posts/mbqwcAgFW#c-qUacwMJeb","author":{"@type":"Person","name":"cevheri","url":"https://daily.dev/cevheri","image":"https://avatars.githubusercontent.com/u/12383547?v=4"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":7}},{"@type":"Comment","text":"supporting 46 backends through one UI is ambitious, that kind of breadth usually comes at the cost of each driver being shallow. how deep does the mongo/cassandra support actually go vs just basic CRUD?","datePublished":"2026-10-02T18:17:05.785Z","url":"https://daily.dev/posts/mbqwcAgFW#c-hFl9xgAXH","author":{"@type":"Person","name":"PDFops","url":"https://daily.dev/pdfopsdev","image":"https://media.daily.dev/image/upload/s---8isRBKc--/f_auto/v1782922291/avatars/avatar_orjMeK8QKaaVZwGq7ScPz?_a=BAMAMicg0"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1}},{"@type":"Comment","text":"@hardik15 That is why the grid doesn’t load everything at once by default. The query runs on the server side right next to the database and the relevant tab fetches only one page of data: a SELECT query without a LIMIT clause returns 500 rows, while the “Load More” option retrieves the next 500 rows upon request. Loading the entire dataset requires your confirmation first and stops at 100,000 rows. The grid uses a virtualized structure; therefore, regardless of how many rows are loaded, only those visible on the screen are processed and displayed.\nThe loaded rows are kept in the tab’s memory, just as they would be in any client displaying data; consequently, for a dataset containing millions of rows, I would still prefer to use a script or the database engine’s own export (dump) tool. If you try the tool on one of your larger tables, I’d love to hear how it performs.\nI’m currently testing it on a live database with 6,000 tables (some containing millions of rows), and I haven’t encountered any issues except with the ER diagram.","datePublished":"2026-10-05T14:10:46.531Z","url":"https://daily.dev/posts/mbqwcAgFW#c-3WDE6ipSW","author":{"@type":"Person","name":"cevheri","url":"https://daily.dev/cevheri","image":"https://avatars.githubusercontent.com/u/12383547?v=4"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1}},{"@type":"Comment","text":"46 databases in one browser tab is both impressive and slightly threatening.","datePublished":"2026-10-07T14:15:25.390Z","url":"https://daily.dev/posts/mbqwcAgFW#c-I9eiqexUW","author":{"@type":"Person","name":"Risto Tõldsep","url":"https://daily.dev/ristotoldsep","image":"https://lh3.googleusercontent.com/a/ACg8ocLDWc6mZn0JwNmXXw6WY0L_HJ6pegzRttooC5VgtXESHSj3MNYx=s96-c"}},{"@type":"Comment","text":"That’s a great to start with, or hear at the first place;\nHowever the biggest worry or issue I can foresee is the memory consumption or lag on production, or even a thousand of rows.\nMany browser tabs are already memory hungry and people already had a good number of tabs opens, when you open this as well on the tab, it we acquire more and more memory than a stand-alone app unless you use it mainly for schema or very limited rows use cases.\nI had similar kind of experience in Google Sheets few years before. I had thousands of rows of data in a sheet, initially it is very smooth however as the data increases the lag and speed is decressed and even affected system performance of the Mac is affected.","datePublished":"2026-10-05T06:06:04.641Z","url":"https://daily.dev/posts/mbqwcAgFW#c-QLnbSVHJU","author":{"@type":"Person","name":"Hardik","url":"https://daily.dev/hardik15","image":"https://media.daily.dev/image/upload/s--O0TOmw4y--/f_auto/v1715772965/public/noProfile"}}],"isPartOf":{"@type":"WebPage","url":"https://daily.dev/sources/j6gjfvntm6h4f4hblpc77","name":"cevheri"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"cevheri","item":"https://daily.dev/sources/j6gjfvntm6h4f4hblpc77"},{"@type":"ListItem","position":3,"name":"LibreDB Studio: a self-hosted SQL IDE that runs in your browser, for 46 databases"}]} ```