⭐ +90 today Rust

t8y2/dbx

🔗 https://github.com/t8y2/dbx ↗

90+ databases in 25 MB. Desktop, Docker, CLI, built-in AI assistant, and MCP Server. English | 前往中文版本 ❤️ Sponsors RainYun is a cloud service provider offering cloud servers, physical servers, game hosting, and developer-friendly infrastructure services. Visit RainYun TrustAsia provides cloud-based code signing service for DBX, enabling trusted software through automated CI/CD builds. Visit TrustAsia Jalapeño Cloud is an AI infrastructure and token compute platform, with an exclusive DBX entry offering free credits and top-up bonuses. Visit Jalapeño Cloud UCloud is the first public cloud provider listed on China's STAR Market, with 28 global regions for cloud hosting, databases, and CDN; its AstraFlow platform offers one-click access to 200+ mainstream LLMs. Visit UCloud HuaLongAI is a model API relay built for heavy AI developers, offering 100% official-source Codex and Claude models with transparent token-level billing, enterprise contracts, and invoicing. Visit HuaLongAI Atlas Cloud gives developers one unified API for 400+ AI models across chat, image, video, and audio. Visit Atlas Cloud Qiniu Cloud provides DBX with object storage, CDN, and other cloud infrastructure resources. Visit Qiniu Cloud 🤝 Partners 1Panel is a modern open-source Linux server management panel and lightweight AI management platform, offering an intuitive web interface for one-stop management of AI agents, local LLMs, websites, databases, containers, files, and more. Visit 1Panel Easysearch is an enterprise-grade distributed search engine compatible with Elasticsearch APIs, combining full-text, vector, geospatial search, real-time analytics, and AI capabilities in one platform. Visit Easysearch Why DBX? 🪶 25 MB, zero runtime bloat No Java JRE. No Python venv. No bundled Chromium. DBX ships as a single small binary — download, install, connect. DBeaver needs Java; TablePlus is Freemium. DBX runs everywhere with nothing extra. 🤖 AI that lives in your editor Highlight a table, describe what you want, get SQL back — no copy-paste between tools. Works with Claude, OpenAI, or local models via Ollama. Built-in safety checks review AI-generated SQL before it runs. 🔌 MCP: your databases, AI-ready DBX speaks the Model Context Protocol. Claude Code, Cursor, Windsurf, and other AI coding agents can query your databases through connections you already set up. One config, everywhere. 🌐 Desktop + Docker + Web Native app on macOS, Windows, and Linux. Self-host via Docker for team access. Web version for browser-only environments. Same feature set. Same connections. Features 90+ Databases, One Tool MySQL, PostgreSQL, SQLite, Cloudflare D1, Redis, MongoDB, DuckDB, ClickHouse, SQL Server, Oracle, Elasticsearch, Easysearch, Meilisearch, Qdrant, Milvus, Weaviate, MariaDB, TiDB, OceanBase, openGauss, GaussDB, KWDB, KingbaseES, Vastbase, GoldenDB, Doris, SelectDB, StarRocks, Manticore Search, Redshift, DM, TDengine, XuguDB, CockroachDB, Access, HighGo, UXDB, Dolt, and more. Agent-based profiles extend DBX to H2, Snowflake, Trino, PrestoSQL, Hive, DB2, Informix, Neo4j, Cassandra, BigQuery, Cloud Spanner, Kylin, SunDB, JDBCX, and custom JDBC connections. New native and agent-driven drivers also cover Databricks, SAP HANA, Teradata, Vertica, Firebird, Exasol, YashanDB, GBase 8a/8s, Databend, RQLite, Turso, InfluxDB, QuestDB, IoTDB, etcd, ZooKeeper, Nacos, Consul KV, IRIS, and more. Message queue admin is also available for Pulsar, Kafka, and RocketMQ. All in a single ~25 MB app. No bundled Chromium. Query Editor CodeMirror 6 with SQL syntax highlighting, metadata-aware autocomplete, Cmd+Enter execution, selected SQL execution, SQL formatting, diagnostics, and 9 editor themes. Persistent query history, saved SQL snippets, tab restore, and SQL file execution keep repeat work close at hand. AI SQL Assistant Describe what you want in plain language — get SQL back. DBX can explain queries, optimize SQL, fix errors, and run AI-generated SQL through built-in safety checks. Works with Claude, OpenAI, local models, or any OpenAI-compatible endpoint. Data Grid Virtual-scrolled table that handles large result sets. Inline editing, SQL preview before save, WHERE / ORDER BY controls, DataGrip-style filters, LIKE / NOT LIKE context filters, sorting, full-text search, pagination, column resize, auto-fit, row numbers, zebra stripes, and full cell details. Export or copy as CSV, JSON, Markdown, XLSX, or INSERT statements. Schema Tools Schema browser — databases, schemas, tables, columns, indexes, foreign keys, triggers, with sidebar search & pin Object browser — grouped procedures, functions, views, and source editing where supported Table structure editor — reviewable column and index changes for supported engines ER diagram — visualize table relationships Schema diff — compare structures across connections Explain plan — visual query execution plan Field lineage — column-level lineage analysis Database search — find objects across large schemas Data Operations Table import — CSV, Excel Data transfer — migrate between databases Database export — full database dump Data compare — compare table data and review synchronization output SQL file execution — run .sql files directly File preview — drag & drop Parquet, CSV, JSON to preview instantly (powered by DuckDB) Connection import — bring connection profiles from DBeaver or Navicat Specialized Browsers Redis — key pattern search, batch key operations, command runner, TTL editing, and all data types (String, Hash, List, Set, ZSet, Stream) MongoDB — document CRUD with pagination, Atlas & replica set URL connection Safety & Connectivity SSH tunnel (key & password) · database and AI proxy settings · auto-reconnect on connection loss · confirmation dialogs for destructive operations · encrypted config export/import · color-coded connections · driver store and optional JDBC plugin Polished UI Dark mode with native title bar sync · 9 editor themes · English, 簡體中文 & Español · layout preferences · built-in auto-update AI Agent Integration (MCP) DBX provides a separate Rust-powered MCP server that lets AI coding agents query databases using connections configured in DBX. The MCP server is distributed independently from the desktop application, so installing DBX does not automatically install the MCP executable. npx @dbx-app/mcp-server Add to your .mcp.json : { "mcpServers" : { "dbx" : { "command" : " npx " , "args" : [ " -y " , " @dbx-app/mcp-server " ] } } } Manage the connection allowlist and the Read only , Data read/write , and Full access modes in DBX Settings → MCP . The machine-readable values remain read_only , safe_write , and high_risk_write ; client configs do not need permission or connection-scope environment variables. For upgrade compatibility, an existing DBX_MCP_ALLOW_WRITES=0 (or false ) remains a read-only restriction only until a central MCP policy is saved for the first time; it can never enable writes or override a saved policy. Windows portable builds need DBX_DATA_DIR in the MCP config, pointing to the data directory next to DBX.exe (the folder that contains dbx.db ). For DBX Web or Docker deployments, point the MCP server at the Web backend API. If the Web login page requires a password, set DBX_WEB_PASSWORD to the same password used there: { "mcpServers" : { "dbx" : { "command" : " npx " , "args" : [ " -y " , " @dbx-app/mcp-server " ], "env" : { "DBX_WEB_URL" : " http://localhost:4224 " , "DBX_WEB_PASSWORD" : " your-web-login-password " } } } } Works with Claude Code, Cursor, Windsurf, and any MCP-compatible agent. Supports listing connections, browsing tables, executing SQL, and opening tables directly in DBX's UI. Precompiled native binaries are also published for macOS, Linux, and Windows in package releases . They run without Node.js and are suitable for offline or server environments. The npm installation uses the same Rust binary through a small Node.js launcher.

內容為收集當日抓取的 repo 描述原文,完整資訊請見 GitHub 原頁。