Yes, 100% free and open source under the MIT license. No hidden costs, no premium tiers, no feature limitations. You get the full product, forever. We believe great developer tools should be accessible to everyone.

Absolutely! Self-hosting is a first-class citizen. Deploy with Docker, Kubernetes, or any Node.js environment. Your data stays on your infrastructure, under your control. We provide detailed deployment guides for all major platforms.

We support multiple AI providers out of the box: Google Gemini (default), OpenAI (GPT-4o, GPT-4), Claude, and local LLMs via Ollama or LM Studio. You can also configure any OpenAI-compatible endpoint. Switch providers anytime or run completely offline with local models.

Security is our top priority. All connections support TLS/SSL encryption and SSH Tunnel for accessing databases behind firewalls. Credentials are never stored in plain text. For self-hosted deployments, your data never leaves your network. We support JWT authentication, OIDC Single Sign-On (Auth0, Keycloak, Okta, Azure AD), role-based access control (RBAC), transaction control (BEGIN/COMMIT/ROLLBACK), and automatic data masking — sensitive columns like email, phone, SSN, and financial data are detected and masked across the grid, exports, and clipboard with configurable RBAC enforcement.

Yes! LibreDB Studio supports vendor-agnostic OpenID Connect (OIDC) authentication out of the box. Connect with Auth0, Keycloak, Okta, Azure AD, Google, or any OIDC-compliant identity provider. The integration uses Authorization Code Flow with PKCE for maximum security, supports configurable role mapping from provider claims, and handles both login and logout at the provider level. Just set three environment variables (issuer, client ID, client secret) and you’re ready to go.

We support PostgreSQL, MySQL, Oracle Database, Microsoft SQL Server, SQLite, MongoDB, and Redis. Each adapter is optimized for its specific database with full feature support including schema inspection, query execution, maintenance tools, and monitoring. Oracle uses oracledb Thin mode (pure JavaScript, no Instant Client needed) and SQL Server uses the mssql/tedious driver with Azure SQL auto-detection.

Yes! LibreDB Studio is built mobile-first. The entire UI is touch-optimized and responsive. Check your production database from anywhere - perfect for on-call situations or quick fixes on the go.

No installation required for end users. LibreDB Studio runs entirely in your browser. For self-hosting, you just need Docker or Node.js. That’s it - no Java, no Electron, no heavy desktop apps.

Unlike pgAdmin (PostgreSQL only) or DBeaver (desktop app), LibreDB Studio is web-based, mobile-ready, and deeply AI-powered. Beyond NL2SQL, we offer AI Query Safety Analysis, AI Query Explainer, AI Query Autopilot, AI Data Profiler, ORM Code Generator, Test Data Generator, Interactive Pivot Tables, ER Diagrams, Database Documentation, and automatic Data Masking with RBAC enforcement - features no desktop IDE provides. Zero installation, works on any device.