Summary

Gridex is a native macOS/Windows database IDE for developers and power users, unifying access to seven database systems (PostgreSQL, MySQL, SQLite, Redis, MongoDB, SQL Server, ClickHouse). It offers a fast, keyboard-driven interface, integrated AI schema understanding for SQL generation, and a secure, local MCP server for agent integration, prioritizing local credential management without cloud sync or telemetry.

How It Works

Built natively for macOS (AppKit) and Windows (WinUI 3), Gridex avoids Electron for core UI components. It employs a unified DatabaseAdapter protocol across seven drivers, ensuring consistent features like grids, query editors, ER diagrams, and backups across all engines. AI integration allows LLMs (Claude, GPT, Gemini, Ollama) to parse schemas and generate SQL securely. An embedded MCP server exposes connections and tools to clients (e.g., Claude Desktop, Cursor) with a 3-tier permission model and audit logging, keeping credentials local.

Quick Start & Requirements

• Primary install/run: Build from source via Swift Package Manager. Clone repo, cd gridex, then swift build (debug) or ./scripts/build-app.sh (macOS app bundle).
• Prerequisites:
  • macOS: 14.0+ (Sonoma), Swift 5.10+ / Xcode 15+
  • Windows: 10 (64-bit)+, VS 2022+, .NET 8 SDK, vcpkg
• Links: No explicit quick-start or demo links provided.

Highlighted Details

• Unified Multi-Database Access: Seven drivers in one binary, leveraging native primitives for each.
• Local AI Schema Understanding: LLMs parse schemas, generate SQL; API keys secured locally (macOS Keychain/Windows Credential Manager).
• MCP Server for Agents: Exposes connections/tools with granular permissions and audit trails to clients like Claude Desktop/Cursor, operating locally.
• Native ER Diagrams: Renders live schema diagrams using platform-native technologies, no external dependencies.
• Security-Focused: Local credential storage, no cloud sync, telemetry, or prompt proxying.

Maintenance & Community

Contributions are welcomed via CONTRIBUTING.md and CODE_OF_CONDUCT.md. No specific maintainer, sponsorship, or community channel details are present.

Licensing & Compatibility

• License: Apache License, Version 2.0.
• Compatibility: Permissive license allows commercial/closed-source use, provided copyright/NOTICE files are retained.

Limitations & Caveats

Platform-specific UI frameworks (AppKit vs. WinUI 3) may introduce subtle differences. Windows ER diagram rendering uses an in-process Dagre/WebView, potentially differing from macOS native CoreGraphics. README lacks details on specific bugs or alpha/beta status.