# dbx | skyler | Knowledge Base | Instagit

15MB, lightweight, cross-platform database client. Supports MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, ClickHouse, SQL Server and more.15MB，轻量级跨平台数据库客户端、数据库管理工具。支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、DuckDB、ClickHouse、SQL Server 等。

GitHub Stars: 8.2k

Repository: https://github.com/t8y2/dbx

---

## Articles

### [DBX CLI Error Codes: Complete Reference for Error Handling and Debugging](/t8y2/dbx/dbx-cli-error-codes-and-meanings)

Master DBX CLI error codes with this complete reference. Understand and resolve invalid arguments, connection issues, and more for efficient debugging.

- Tags: api-reference
- Published: 2026-07-10

### [How to Run the DBX MCP Server Against a Docker Deployment](/t8y2/dbx/how-to-run-dbx-mcp-server-against-docker-deployment)

Learn to run the DBX MCP server against a Docker deployment. Set DBX_WEB_URL and DBX_WEB_PASSWORD to connect the containerized DBX web API.

- Tags: how-to-guide
- Published: 2026-07-10

### [How to Export and Encrypt DBX Connection Configurations: A Complete Guide](/t8y2/dbx/how-to-export-and-encrypt-dbx-connection-configurations)

Learn how to export and encrypt DBX connection configurations using AES-GCM. Securely transfer your DBX settings between machines with a passphrase. A complete guide.

- Tags: how-to-guide
- Published: 2026-07-10

### [How DBX Handles Large Result Sets with Virtual Scrolling: Implementation Guide](/t8y2/dbx/how-dbx-handles-large-result-sets-with-virtual-scrolling)

Learn how DBX handles large result sets using virtual scrolling. Discover its implementation with RecycleScroller page-sized fetching and infinite scroll for efficient data loading in t8y2/dbx.

- Tags: how-to-guide
- Published: 2026-07-10

### [How to Configure SSH Tunnel Connections in DBX: A Complete Guide](/t8y2/dbx/how-to-configure-ssh-tunnel-connections-in-dbx)

Learn how to configure SSH tunnel connections in DBX for secure database access. Our guide explains how DBX automatically establishes tunnels for local port forwarding.

- Tags: how-to-guide
- Published: 2026-07-10

### [What Databases Are Supported via Native Drivers vs JDBC Agents in DBX](/t8y2/dbx/dbx-supported-databases-native-vs-jdbc)

DBX supports Oracle & XuguDB with native Go drivers. Discover which other databases connect via JDBC agents for seamless integration.

- Tags: api-reference
- Published: 2026-07-10

### [How to Use DBX Schema Diff to Compare Database Structures: A Complete Guide](/t8y2/dbx/how-to-use-dbx-schema-diff-to-compare-databases)

Learn to use DBX schema diff to compare database structures. This guide covers comparing tables, columns, and functions to generate migration scripts efficiently.

- Tags: how-to-guide
- Published: 2026-07-10

### [How to Import Connections from DBeaver or Navicat into DBX: A Complete Guide](/t8y2/dbx/how-to-import-connections-from-dbeaver-navicat-to-dbx)

Easily import DBeaver or Navicat connections into DBX. Follow this guide to use the Import Connections dialog and convert your existing database configurations into DBX's unified ConnectionConfig objects.

- Tags: how-to-guide
- Published: 2026-07-10

### [How DBX Connection Pooling Works Across MCP Queries: A Technical Deep Dive](/t8y2/dbx/how-dbx-connection-pooling-works-across-mcp-queries)

Understand DBX connection pooling for MCP queries. Learn how DBX reuses existing pooled connections to efficiently manage database requests and avoid new socket creation.

- Tags: deep-dive
- Published: 2026-07-10

### [DBX MCP Security Settings Environment Variables: Complete Configuration Guide](/t8y2/dbx/dbx-mcp-security-environment-variables)

Master DBX MCP security settings with our guide to essential environment variables. Configure write permissions, SQL execution, and authentication for secure operations.

- Tags: how-to-guide
- Published: 2026-07-10

### [How to Configure DBX Web with Password Authentication for MCP](/t8y2/dbx/how-to-configure-dbx-web-with-password-authentication-for-mcp)

Configure DBX Web password authentication for MCP by setting DBX_WEB_PASSWORD. Enable secure, automatic authenticated access to the HTTP API with this guide.

- Tags: how-to-guide
- Published: 2026-07-10

### [How to Deploy DBX Web Behind a Reverse Proxy with Context Path](/t8y2/dbx/how-to-deploy-dbx-web-behind-reverse-proxy-with-context-path)

Deploy DBX Web behind a reverse proxy with context path. Set DBX_PUBLIC_BASE_PATH and configure your proxy to forward requests efficiently.

- Tags: how-to-guide
- Published: 2026-07-10

### [How DBX Agent Versioning and Release Process Works: A Complete Technical Guide](/t8y2/dbx/dbx-agent-versioning-and-release-process)

Understand DBX agent versioning and release process. Learn about semantic versioning, GitHub Actions, and artifact generation in this comprehensive technical guide.

- Tags: internals
- Published: 2026-07-10

### [How to Build a Custom JDBC Database Driver for DBX](/t8y2/dbx/how-to-build-custom-jdbc-driver-for-dbx)

Learn to build a custom JDBC database driver for DBX. Explore loading JDBC drivers as runtime plug-ins using local JARs Maven or bundled plugins.

- Tags: how-to-guide
- Published: 2026-07-10

### [Native vs JDBC Agents in DBX: Understanding the Key Differences](/t8y2/dbx/difference-between-native-and-jdbc-dbx-agents)

Explore native vs JDBC agents in DBX. Understand how Go/Rust agents connect directly versus JDBC agents using a JVM. Learn key differences to optimize your database integrations.

- Tags: deep-dive
- Published: 2026-07-10

### [How to Use DBX CLI for Schema Inspection and Query Execution: A Complete Guide](/t8y2/dbx/how-to-use-dbx-cli-for-schema-inspection-and-query-execution)

Master DBX CLI for schema inspection and query execution. Explore database schemas and run SQL queries with terminal commands from the t8y2/dbx repository. Get results in Markdown JSON or CSV.

- Tags: how-to-guide
- Published: 2026-07-10

### [How DBX Handles SQL Safety Checks in MCP Sessions: A Two-Layer Defense](/t8y2/dbx/how-dbx-handles-sql-safety-checks-in-mcp-sessions)

DBX secures MCP sessions with a two-layer defense combining Node-side evaluation and Rust-side risk classification for safe, read-only SQL execution by default.

- Tags: how-to-guide
- Published: 2026-07-10

### [Database Types That Support Direct Execution Without DBX Desktop](/t8y2/dbx/what-database-types-support-direct-execution-without-dbx-desktop)

Discover database types like PostgreSQL MySQL and SQLite that support direct DBX execution without the Desktop app. Connect directly via CLI.

- Tags: how-to-guide
- Published: 2026-07-10

### [How to Configure the DBX MCP Server for Windows Portable Builds](/t8y2/dbx/how-to-configure-dbx-mcp-server-for-windows-portable-builds)

Configure the DBX MCP server for Windows portable builds by setting the DBX_DATA_DIR environment variable. Learn how to point to your portable data folder for seamless operation.

- Tags: how-to-guide
- Published: 2026-07-10

### [DBX MCP Server Integration with Claude Code and Cursor: A Complete Guide](/t8y2/dbx/how-dbx-mcp-server-integration-works-with-claude-code-and-cursor)

Integrate DBX MCP server with Claude Code and Cursor to securely query databases. Expose DBX connections as Model Context Protocol tools for AI agents via STDIO.

- Tags: how-to-guide
- Published: 2026-07-10

### [How DBX's ER Diagram Visualizes Table Relationships: Chen-Style SVG Generation](/t8y2/dbx/how-does-dbx-er-diagram-visualize-table-relationships)

DBX visualizes table relationships with Chen-style SVG connectors. Learn how DBX scans foreign keys to render ER diagrams, showing referential integrity and cardinality between tables.

- Tags: deep-dive
- Published: 2026-07-09

### [How to Use DBX's Redis Browser for Key Pattern Search](/t8y2/dbx/how-to-use-dbx-redis-browser-for-key-pattern-search)

Learn how to use DBX's Redis browser for key pattern search with the redisKeySearchPattern function. Find keys using glob patterns and fuzzy matching in the desktop interface.

- Tags: how-to-guide
- Published: 2026-07-09

### [How to Export Data from DBX in JSON Format](/t8y2/dbx/how-to-export-data-from-dbx-in-json-format)

Easily export data from DBX to JSON format using the text_export module. Get query results as pretty-printed JSON with UTF-8 BOM encoding for web APIs and desktop files.

- Tags: how-to-guide
- Published: 2026-07-09

### [How to Export Data from DBX in CSV Format: CLI, Core Library, and Desktop Methods](/t8y2/dbx/how-to-export-data-from-dbx-in-csv-format)

Export DBX data to CSV using CLI, Rust core library, or desktop app. Stream results, format with UTF-8 BOM headers, or write paginated tables directly to disk. Learn three easy methods.

- Tags: how-to-guide
- Published: 2026-07-09

### [How DBX Handles SSH Tunnel Connections with Password Authentication](/t8y2/dbx/how-does-dbx-handle-ssh-tunnel-connections-with-password-authentication)

Learn how DBX handles SSH tunnel connections with password authentication by retrieving encrypted secrets and using Rust for secure, asynchronous authentication. Debug credential failures with clear error messages.

- Tags: how-to-guide
- Published: 2026-07-09

### [How to Set Up DBX Multi-Arch Deployment: Cross-Platform Container Builds](/t8y2/dbx/how-to-set-up-dbx-multi-arch-deployment)

Learn how to set up DBX multi-arch deployment for cross-platform container builds using Docker BuildKit. Effortlessly deploy on amd64 and arm64.

- Tags: how-to-guide
- Published: 2026-07-09

### [How to Deploy DBX with Docker: A Complete Self-Hosting Guide](/t8y2/dbx/how-to-deploy-dbx-with-docker)

Deploy DBX with Docker using this complete self-hosting guide. Learn to package the Vue 3 frontend and Rust backend into a minimal Debian image for easy setup.

- Tags: how-to-guide
- Published: 2026-07-09

### [How DBX's AI SQL Assistant Works with OpenAI: Architecture and Implementation](/t8y2/dbx/how-does-dbx-ai-sql-assistant-work-with-openai)

Discover how DBX's AI SQL assistant works with OpenAI to streamline your SQL queries. Learn about its architecture, implementation, and seamless integration for enhanced database interactions.

- Tags: architecture
- Published: 2026-07-09

### [How to Build DBX from Source: Complete Guide for Rust, Tauri, and Vue](/t8y2/dbx/guide-to-build-dbx-from-source-development-and-build)

Learn to build DBX from source in this comprehensive guide. Compile Rust, Vue, and Tauri into native desktop installers with a single make package command. Get the complete instructions here.

- Tags: how-to-guide
- Published: 2026-07-08

### [How to Compare Database Schemas Using DBX Schema Diff: A Complete Guide](/t8y2/dbx/how-to-compare-database-schemas-using-dbx-schema-diff)

Compare database schemas with DBX Schema Diff. Analyze differences across PostgreSQL, MySQL, and more. Generate SQL migration scripts easily.

- Tags: how-to-guide
- Published: 2026-07-08

### [Common DBX Connection Issues and How to Troubleshoot Them](/t8y2/dbx/troubleshooting-common-dbx-connection-issues)

Resolve common DBX connection issues like corrupted stores, missing secrets, or proxy problems. Learn to troubleshoot efficiently using inspectConnectionStore and node-core.

- Tags: how-to-guide
- Published: 2026-07-08

### [How to Integrate DBX with AI Providers Like Claude, OpenAI, and Ollama](/t8y2/dbx/how-to-integrate-dbx-with-ai-providers-claude-openai-ollama)

Integrate DBX with AI providers like Claude, OpenAI, and Ollama using its Rust core engine for seamless configuration and endpoint management. Simplify your AI workflow today.

- Tags: how-to-guide
- Published: 2026-07-08

### [How to Connect to Redis and Execute Commands Using DBX](/t8y2/dbx/how-to-connect-to-redis-and-execute-commands-in-dbx)

Learn to connect to Redis and run commands with DBX. This guide covers native ioredis clients and HTTP bridge for Sentinel, simplifying your Redis interactions.

- Tags: how-to-guide
- Published: 2026-07-08

### [How to Configure MCP Server with DBX for AI Agent Integration](/t8y2/dbx/how-to-configure-mcp-server-with-dbx-for-ai-agent-integration)

Integrate AI agents with your databases using DBX's MCP server. Learn to configure MCP server with DBX for seamless AI coding agent interaction. Explore AI agent capabilities.

- Tags: how-to-guide
- Published: 2026-07-08

### [DBX: A Lightweight Database Manager Built in Rust for 60+ Engines](/t8y2/dbx/lightweight-database-manager-rust)

Discover DBX, a lightweight Rust database manager for 60+ engines. Enjoy a Vue 3 frontend with AI-powered queries and cross-platform support. Manage databases efficiently.

- Tags: getting-started
- Published: 2026-07-07

### [How Many Databases Does dbx Support? A Complete Guide to All 62 Supported Database Types](/t8y2/dbx/how-many-databases-does-dbx-support)

Discover the 62 databases dbx supports. This comprehensive guide covers relational, NoSQL, and vector databases, ensuring seamless integration for your projects.

- Tags: deep-dive
- Published: 2026-07-07

### [How to Use Local AI Models with DBX's AI SQL Assistant: Ollama & OpenAI-Compatible Setup](/t8y2/dbx/can-i-use-local-ai-models-with-dbxs-ai-sql-assistant)

Use local AI models with DBX's AI SQL Assistant! Discover how to integrate Ollama and OpenAI-compatible endpoints for seamless local deployments. Get started today.

- Tags: how-to-guide
- Published: 2026-07-06

### [What Data Operations Can Be Performed with DBX: Complete API Reference](/t8y2/dbx/what-data-operations-can-be-performed-with-dbx)

Explore DBX API for four key data operations: list tables, describe schema, execute queries, and run commands. Unified API works across PostgreSQL MySQL MongoDB Redis SQLite.

- Tags: api-reference
- Published: 2026-07-06

### [How to Integrate AI Agents with DBX Using MCP: A Complete Technical Guide](/t8y2/dbx/how-can-i-integrate-ai-agents-with-dbx-using-mcp)

Learn to integrate AI agents with DBX using MCP a complete technical guide. Connect coding assistants like Claude Code and Cursor to your databases via Node.js.

- Tags: how-to-guide
- Published: 2026-07-06

### [How DBX Detects Database Capabilities Dynamically at Runtime](/t8y2/dbx/dbx-runtime-database-capabilities-detection)

Learn how DBX dynamically detects database capabilities at runtime using a JSON-RPC handshake. Adapt your applications without client rebuilds.

- Tags: internals
- Published: 2026-07-05

### [How DBX Manages and Adapts to Different SQL Dialects Across Various Databases](/t8y2/dbx/dbx-sql-dialect-handling-databases)

Discover how DBX manages SQL dialects across databases like MySQL, PostgreSQL, and DuckDB. Learn about its capability modules, driver implementations, and query builders for seamless adaptation without hard-coding.

- Tags: internals
- Published: 2026-07-05

### [Authentication Methods DBX Supports When Connecting to AI Providers](/t8y2/dbx/dbx-ai-provider-authentication-methods)

Learn authentication methods DBX supports for AI providers. Explore API key and Bearer token options for seamless integration and enhanced security.

- Tags: api-reference
- Published: 2026-07-05

### [How DBX Implements Cloud Synchronization for Database Connections](/t8y2/dbx/dbx-cloud-sync-database-connections)

Discover how DBX implements secure cloud synchronization for database connections. Learn about encrypted snapshots, WebDAV transmission, and AES-256-GCM protection for your data.

- Tags: internals
- Published: 2026-07-05

### [DuckDB Worker Process Architecture in DBX: Isolated File Preview System](/t8y2/dbx/dbx-duckdb-worker-process-file-previews)

Explore the DuckDB worker process architecture in DBX, isolating file previews for a responsive UI and preventing crashes with heavy operations. Learn how DBX ensures stability.

- Tags: architecture
- Published: 2026-07-05

### [How DBX Handles PostgreSQL Transaction Recovery: Detecting ROLLBACK, COMMIT, and ABORT Commands](/t8y2/dbx/dbx-transaction-recovery-postgresql)

Learn how DBX handles PostgreSQL transaction recovery, detecting ROLLBACK, COMMIT, and ABORT commands to prevent errors. Understand its special statement logic.

- Tags: internals
- Published: 2026-07-05

### [How to Export Query Results from DBX to XLSX, CSV, and JSON](/t8y2/dbx/dbx-export-query-results-xlsx-csv-json)

Easily export DBX query results to XLSX, CSV, and JSON. Learn how to serialize your data for desktop UI and CLI access.

- Tags: how-to-guide
- Published: 2026-07-05

### [DBX Multi-Provider AI Integration Architecture: A Technical Deep Dive](/t8y2/dbx/dbx-multi-provider-ai-integration-architecture)

Explore the DBX multi provider AI integration architecture. Learn how DBX unifies communication with OpenAI, Claude, Gemini, and more through a single abstraction layer. Technical deep dive.

- Tags: deep-dive
- Published: 2026-07-05

### [How DBX Performs AI-Driven SQL Generation with Built-in Safety Checks](/t8y2/dbx/dbx-ai-sql-generation-safety-checks)

Learn how DBX performs AI-driven SQL generation with robust built-in safety checks. Discover how it blocks dangerous keywords and multi-statements for secure database operations.

- Tags: how-to-guide
- Published: 2026-07-05

### [How DBX Integrates with Nacos for Service Discovery](/t8y2/dbx/dbx-nacos-service-discovery-integration)

Discover how DBX integrates with Nacos for seamless service discovery. Learn how its Rust core module leverages the Nacos HTTP API for Tauri desktop and web applications.

- Tags: how-to-guide
- Published: 2026-07-05

### [Which Message Queue Systems Are Supported by DBX for Administrative Operations?](/t8y2/dbx/dbx-message-queue-systems-admin-operations)

Discover which message queue systems DBX supports for administrative operations. Learn about Apache Pulsar's full capabilities and Kafka's topic-focused functionality.

- Tags: api-reference
- Published: 2026-07-05

### [SQL Editability Analysis in DBX: How Query Modification Detection Works](/t8y2/dbx/dbx-sql-editability-analysis-implementation)

Learn how DBX performs SQL editability analysis by parsing queries and applying syntactic checks to enable safe query modifications for updates, inserts, and deletes.

- Tags: internals
- Published: 2026-07-05

### [How DBX Generates SQL for Data Grid and Virtual‑Scrolled Tables](/t8y2/dbx/dbx-data-grid-sql-generation-virtual-scroll)

Learn how DBX generates database-agnostic SQL for data grids and virtual-scrolled tables. Discover its pipeline for converting metadata and pagination into dialect-specific SELECT statements.

- Tags: how-to-guide
- Published: 2026-07-05

### [Exporting Database Schema and Table Data with DBX: JSON-RPC Methods and Driver Implementation](/t8y2/dbx/dbx-database-export-data-structure)

Export database schema and table data using DBX JSON-RPC methods. Discover schema, generate DDL, and stream large results efficiently.

- Tags: how-to-guide
- Published: 2026-07-05

### [How DBX Implements Table Data Import from CSV and Excel Files: A Technical Deep Dive](/t8y2/dbx/dbx-table-import-csv-excel)

Learn how DBX handles CSV and Excel imports with its three-stage pipeline. Discover format detection, JSON parsing, and batched SQL inserts for efficient data loading.

- Tags: deep-dive
- Published: 2026-07-05

### [How DBX Schema Difference Detection Works: Hash-Based Set Comparison Algorithm](/t8y2/dbx/dbx-schema-diff-algorithm)

Discover how DBX uses a hash-based set comparison algorithm for efficient schema difference detection. Learn about its two-phase diff process comparing names and metadata.

- Tags: internals
- Published: 2026-07-05

### [What Redis Operations Are Supported by DBX: Pattern Search and Key Scanning](/t8y2/dbx/dbx-redis-operations-key-pattern-search)

Discover DBX's supported Redis operations including efficient key pattern search. Learn how DBX leverages Rust SCAN for single-node and cluster connections with batch aggregation.

- Tags: how-to-guide
- Published: 2026-07-05

### [How DBX Facilitates MongoDB Document Operations and CRUD Tasks: Architecture and Implementation](/t8y2/dbx/dbx-mongodb-document-operations-crud)

Explore how DBX simplifies MongoDB document operations and CRUD tasks with its unified async API and efficient `document_ops.rs` implementation. Learn about its architecture and key features.

- Tags: how-to-guide
- Published: 2026-07-05

### [Architectural Design of DBX's Agent Runtime for JDBC Connections](/t8y2/dbx/dbx-agent-runtime-architecture-jdbc)

Explore the robust architectural design of DBX's agent runtime for JDBC connections. Learn how isolated agents ensure uniform, secure database interactions.

- Tags: architecture
- Published: 2026-07-05

### [How DBX Manages Connection Pooling for Diverse Database Types](/t8y2/dbx/dbx-connection-pooling-database-types)

Discover how DBX manages connection pooling for various database types using Go's database/sql. Optimize your connections with configurable pool limits.

- Tags: internals
- Published: 2026-07-05

### [How DBX Performs Query Execution and SQL Risk Analysis: A Deep Dive](/t8y2/dbx/dbx-query-execution-sql-risk-analysis)

Learn how DBX executes queries and analyzes SQL risks with its layered architecture. Discover AST parsing and keyword detection for security before database dispatch.

- Tags: deep-dive
- Published: 2026-07-05

### [Which Database Drivers Are Compatible with DBX's JDBC Plugin System?](/t8y2/dbx/dbx-jdbc-plugin-database-drivers)

Discover which database drivers are compatible with DBX's JDBC plugin system. Currently, only Xugu and Oracle are supported for seamless integration.

- Tags: api-reference
- Published: 2026-07-05

### [SSH Tunnel Connections in DBX: Key and Password Authentication Methods](/t8y2/dbx/dbx-ssh-tunnel-connections-authentication)

Explore SSH tunnel authentication methods in DBX including private key files and passwords. Learn to secure your DBX connections with detailed configuration insights.

- Tags: how-to-guide
- Published: 2026-07-05

### [How DBX Integrates with AI Assistants Using the MCP Protocol](/t8y2/dbx/how-dbx-integrates-ai-assistants-mcp-protocol)

Learn how DBX integrates with AI assistants such as Claude Code and Cursor using the MCP protocol. This guide explains how the MCP server package enables SQL execution and connection management via JSON-RPC.

- Tags: how-to-guide
- Published: 2026-07-05

### [Architecture of DBX's External DuckDB Cache for Instant File Previews](/t8y2/dbx/dbx-duckdb-cache-architecture-instant-file-preview)

Discover the architecture of DBX's external DuckDB cache. Learn how it materializes local table snapshots via ExternalPool to provide instant file previews and eliminate network latency.

- Tags: architecture
- Published: 2026-07-04

### [What AI Authentication Methods Does DBX Support? API Key and Bearer Tokens Explained](/t8y2/dbx/dbx-ai-authentication-methods-api-key-bearer-tokens)

Learn about DBX AI authentication methods including API Keys and Bearer tokens. Understand how these methods secure your AI integrations effectively.

- Tags: api-reference
- Published: 2026-07-04

### [DBX History Module Architecture: Tracking and Restoring Query States](/t8y2/dbx/dbx-history-module-architecture-query-state-restoration)

Explore the DBX history module architecture, a four-layer system in Rust, SQLite, Tauri, and Pinia for robust query tracking and one-click state restoration.

- Tags: architecture
- Published: 2026-07-04

### [How DBX Handles Full Database Export and Cross-Engine Data Transfer](/t8y2/dbx/dbx-full-database-export-data-transfer-engines)

DBX exports full databases via an async pipeline, discovering schema, sorting dependencies, and generating SQL dumps for seamless transfer between MySQL, PostgreSQL, Oracle, and Dameng.

- Tags: how-to-guide
- Published: 2026-07-04

### [DBX File Validator Mechanism for CSV, Excel, and Parquet Uploads](/t8y2/dbx/dbx-file-validator-mechanism-upload-validation)

Explore the DBX file validator mechanism for CSV, Excel, and Parquet uploads. Learn how DBX ensures data integrity with its three-layer extension-based system, preventing malformed file processing.

- Tags: how-to-guide
- Published: 2026-07-04

### [How DBX Implements Its Schema Browser with Sidebar Search, Pinning, and Object Grouping](/t8y2/dbx/dbx-schema-browser-implementation-search-pinning-grouping)

Discover how DBX implements its schema browser feature leveraging a TreeNode structure SidebarLayout fuzzy search filtering pin ordering and object grouping for efficient data exploration

- Tags: internals
- Published: 2026-07-04

### [DBX Virtual-Scrolled Data Grid Architecture for Large Result Sets: Technical Implementation Guide](/t8y2/dbx/dbx-virtual-scrolled-data-grid-architecture-large-results)

Explore DBX virtual-scrolled data grid architecture for large result sets. Learn how to render millions of rows efficiently with constant memory and seamless pagination.

- Tags: architecture
- Published: 2026-07-04

### [DBX Connection Retry and Auto-Reconnect Mechanism: How It Handles Lost Database Connections](/t8y2/dbx/dbx-connection-retry-auto-reconnect-mechanism)

DBX automatically retries database operations twice on connection loss. Learn how its retry and auto-reconnect mechanism ensures seamless query execution without intervention.

- Tags: internals
- Published: 2026-07-04

### [How DBX Implements MongoDB Document CRUD Operations with Pagination](/t8y2/dbx/dbx-mongodb-crud-operations-pagination)

Learn how DBX implements MongoDB CRUD with pagination. It uses shell-style commands, server-side skip/limit, and client-side row caps for efficient data handling.

- Tags: how-to-guide
- Published: 2026-07-04

### [Architecture of DBX's Agent Service for JDBC Databases: Snowflake, Hive, and BigQuery](/t8y2/dbx/dbx-agent-service-architecture-jdbc-databases)

Explore DBX's modular agent service architecture for unifying JDBC database access across Snowflake, Hive, and BigQuery. Learn about its JSON-RPC design and driver implementations.

- Tags: architecture
- Published: 2026-07-04

### [How DBX Ensures AI SQL Safety: Validating Queries Before Execution](/t8y2/dbx/dbx-ai-sql-safety-checks-execution)

DBX ensures AI SQL safety by validating queries before execution. Learn how DBX enforces read-only defaults, blocks dangerous keywords, and requires WHERE clauses for secure AI data access.

- Tags: deep-dive
- Published: 2026-07-04

### [Which Vector Databases Does DBX Support? Qdrant, Milvus, and Weaviate Integration Explained](/t8y2/dbx/dbx-vector-database-support-integration-qdrant-milvus-weaviate)

Discover DBX support for Qdrant, Milvus, and Weaviate via its unified Rust driver. Integrate vector databases seamlessly with the VectorClient interface.

- Tags: deep-dive
- Published: 2026-07-04

### [How DBX Handles MySQL Connection Modes: Normal, Bare, and OceanBase Oracle](/t8y2/dbx/dbx-mysql-connection-modes-oceanbase-oracle-compatibility)

Learn how DBX intelligently handles Normal, Bare, and OceanBase Oracle MySQL connection modes by automatically detecting and routing operations for seamless integration.

- Tags: deep-dive
- Published: 2026-07-04

### [DBX MCP Server Architecture for AI Agent Integration: A Technical Deep Dive](/t8y2/dbx/dbx-mcp-server-architecture-ai-agent-integration)

Explore the DBX MCP server architecture for seamless AI agent integration. This technical deep dive covers Node.js STDIO and optional Rust TCP bridge for database and UI connections.

- Tags: architecture
- Published: 2026-07-04

### [How DBX Performs Schema Diff and Comparison Between Different Database Connection Profiles](/t8y2/dbx/dbx-schema-diff-comparison-connection-profiles)

Learn how DBX performs schema diff and comparison between database connection profiles. DBX collects metadata, builds a diff model, and generates SQL synchronization scripts.

- Tags: how-to-guide
- Published: 2026-07-04

### [How to Export Query Results from DBX in CSV, JSON, XLSX, and Markdown](/t8y2/dbx/dbx-export-query-results-formats-csv-json-xlsx-markdown)

Learn to export DBX query results in CSV, JSON, XLSX, and Markdown formats. Utilize Tauri commands for seamless serialization from Rust backend to disk via UI or CLI.

- Tags: how-to-guide
- Published: 2026-07-04

### [DBX Plugin System Architecture for JDBC Driver Extensions: Filesystem-Based Driver Management](/t8y2/dbx/dbx-plugin-system-architecture-jdbc-drivers)

Explore DBX's filesystem-based plugin system for JDBC drivers. Discover how DBX manages versioned plugins in ~/.dbx/plugins/jdbc/ with atomic installation and Maven coordinate resolution.

- Tags: architecture
- Published: 2026-07-04

### [Which Message Queue Systems Does DBX Support for Admin Functionality?](/t8y2/dbx/dbx-message-queue-support-admin-functionality)

Discover which message queue systems DBX supports for admin tasks. Learn about Pulsar, Kafka, and RocketMQ integration in t8y2/dbx.

- Tags: how-to-guide
- Published: 2026-07-04

### [How DBX Implements SSH Tunnel Connections for Secure Database Access](/t8y2/dbx/dbx-ssh-tunnel-connections-secure-access)

Discover how DBX implements SSH tunnel connections for secure database access. Learn about its layered transport, authentication, and traffic forwarding using the russh crate.

- Tags: how-to-guide
- Published: 2026-07-04

### [DBX AI Providers: Supported LLMs, API Styles, and Authentication Methods](/t8y2/dbx/dbx-supported-ai-providers-api-authentication)

Explore DBX AI providers, supported LLMs like Claude and Gemini, API styles, and authentication methods. Discover how DBX integrates with various AI services seamlessly.

- Tags: api-reference
- Published: 2026-07-04

### [How DBX Handles Connection Pooling for MySQL, PostgreSQL, and Redis](/t8y2/dbx/dbx-connection-pooling-mysql-postgresql-redis)

Learn how DBX centralizes connection pooling for MySQL, PostgreSQL, and Redis using a thread-safe HashMap in AppState. Discover lazy initialization and efficient connection management.

- Tags: internals
- Published: 2026-07-04

### [How to Export Data from the DBX Data Grid: Complete Guide to CSV, JSON, XLSX, and SQL](/t8y2/dbx/how-to-export-data-from-dbx-data-grid)

Easily export data from the DBX data grid to CSV, JSON, XLSX, and SQL. Learn how to use the useDataGridExport composable for frontend or backend streaming of your data.

- Tags: how-to-guide
- Published: 2026-07-03

### [How to Use DBX AI SQL Assistant to Optimize SQL Queries](/t8y2/dbx/how-to-use-dbx-ai-sql-assistant-to-optimize-sql)

Optimize SQL queries using DBX AI SQL Assistant. Get instant suggestions like CREATE INDEX statements by invoking the optimize action or calling the completion assistant endpoint.

- Tags: how-to-guide
- Published: 2026-07-03

### [Redis Key-Pattern Search in DBX: Architecture and Implementation](/t8y2/dbx/redis-operations-dbx-key-pattern-search)

Explore DBX's Redis key-pattern search using a Tauri-Rust architecture. Learn how batched SCAN operations optimize performance for standalone and cluster Redis.

- Tags: architecture
- Published: 2026-07-02

### [Dynamic Driver Loading in DBX: How External Database Drivers Are Discovered and Loaded at Runtime](/t8y2/dbx/dynamic-driver-loading-in-dbx)

Explore dynamic driver loading in DBX. Learn how DBX discovers and loads external database drivers like JDBC, Redis, and MongoDB at runtime for seamless, hot-swappable integration without restarts.

- Tags: internals
- Published: 2026-07-02

### [Managing Pulsar Queues with DBX: A Complete Guide to Apache Pulsar Administration](/t8y2/dbx/managing-pulsar-queues-with-dbx)

Master Apache Pulsar queue management with DBX. This guide covers tenants, namespaces, topics, and subscriptions using a powerful Rust backend and Vue frontend for seamless administration.

- Tags: how-to-guide
- Published: 2026-07-02

### [Using the DBX Query Editor with CodeMirror 6: Implementation Guide](/t8y2/dbx/using-dbx-query-editor-with-codemirror-6)

Integrate DBX Query Editor with CodeMirror 6 for a powerful SQL editing experience. Learn implementation in this Vue 3 guide. Features lazy loading, themes and completions.

- Tags: how-to-guide
- Published: 2026-07-02

### [Schema Diff and Comparison Between Databases Using DBX: A Technical Guide](/t8y2/dbx/schema-diff-comparison-between-databases-using-dbx)

Easily perform schema diff and comparison between databases with DBX. Visualize changes and generate migration scripts using this powerful tool's CLI, UI, or MCP server.

- Tags: how-to-guide
- Published: 2026-07-02

### [How DBX Handles Query Execution Across Different Databases](/t8y2/dbx/how-dbx-handles-query-execution-across-different-databases)

DBX centralizes query execution via dbx_core::query, unifying database type detection, connection pooling, and driver delegation for normalized results.

- Tags: internals
- Published: 2026-07-02

### [DBX Connection Pooling for Multiple Databases: How AppState Manages Concurrent Connections](/t8y2/dbx/dbx-connection-pooling-for-multiple-databases)

Explore DBX connection pooling for multiple databases. Learn how AppState efficiently manages concurrent connections using a centralized registry for optimal database performance.

- Tags: how-to-guide
- Published: 2026-07-02

### [Implementing the MCP Server in DBX for AI Agent Integration: A Complete Developer's Guide](/t8y2/dbx/implementing-mcp-server-in-dbx-for-ai-agent-integration)

Integrate AI agents with DBX using the MCP server. This guide shows developers how to securely query databases via Node.js with safety gates and UI options.

- Tags: how-to-guide
- Published: 2026-07-02

### [How to Use DBX JDBC Agent Drivers with Hive: A Complete Implementation Guide](/t8y2/dbx/how-to-use-dbx-jdbc-agent-drivers-with-hive)

Learn how to use DBX JDBC agent drivers with Hive using the dedicated HiveAgent class. This guide simplifies Hive database access with JSON-RPC and automatic schema handling.

- Tags: how-to-guide
- Published: 2026-07-02