Reindeer DB - Universal Database Manager

A powerful database management extension for VS Code and Cursor, supporting all major databases via JDBC drivers. Features AI integration through MCP (Model Context Protocol) for intelligent database operations.

Report Issues

Features

Core Capabilities

• Universal JDBC Support - Works with any database that has JDBC drivers
• AI Integration - Full MCP support for Cursor AI with automatic configuration
• Visual Database Explorer - Browse schemas, tables, columns, and indexes in tree view
• SQL Editor - Execute queries with syntax highlighting and auto-completion
• Smart Results - Table view for query results with pagination
• Auto Driver Management - Automatically downloads and manages common JDBC drivers

AI Integration (MCP)

• Auto-Configuration - Extension automatically prompts to configure MCP
• Database Context - AI can read complete database schema
• Schema Resources - Expose table structures to AI for intelligent queries
• Safe Execution - Automatic validation of AI-generated SQL queries
• VS Code Chat - Integration with @reindeer-db chat participant

Supported Databases

Open Source:

• PostgreSQL
• MySQL / MariaDB
• H2
• SQLite

Commercial:

• Oracle Database
• Microsoft SQL Server
• DB2
• Sybase
• Informix

Chinese Domestic:

• DM (达梦数据库)
• KingBase (人大金仓)
• GBase (南大通用)
• Oscar (神舟通用)

And any other JDBC-compatible database

Installation

From Marketplace

1. Open VS Code or Cursor
2. Go to Extensions (Cmd+Shift+X or Ctrl+Shift+X)
3. Search for "Reindeer DB"
4. Click Install

Manual Installation

code --install-extension reindeer-db-0.1.8.vsix

Quick Start

1. Add Database Connection

1. Click the Reindeer DB icon in the sidebar
2. Click the + button
3. Fill in connection details (driver will be auto-downloaded)
4. Save connection

2. Connect and Explore

1. Click the connection icon to connect
2. Expand the tree to browse database structure
3. Right-click on tables to preview data or view structure

3. Execute SQL Queries

1. Create a new .sql file
2. Write your SQL query
3. Press F5 to execute
4. View results in the output panel

MCP Integration for Cursor AI

Automatic Setup (Recommended)

Method 1: Auto-Prompt

The extension will automatically prompt you when you first open a project:

Reindeer DB: Would you like to configure MCP integration for Cursor AI?

Click "Configure Now" and the extension will:

• Automatically detect the correct path
• Create .cursor/mcp.json with proper configuration
• Ready to use after reloading Cursor

Method 2: Use Command

1. Open Command Palette (Cmd+Shift+P)
2. Run: Reindeer DB: Generate MCP Configuration
3. Choose an option:
   • Copy to Clipboard
   • Create .cursor/mcp.json automatically
   • Show configuration

Available MCP Tools

• list_connections - List all database connections
• get_database_info - Get database details (type, version, features)
• list_database_objects - List tables, views, procedures
• describe_tables - Get table structures
• execute_query - Execute read-only SQL (SELECT/SHOW)
• execute_update - Execute write operations (requires confirmation)

MCP Resources

• reindeer://connections - All database connections
• reindeer://database/{id}/schema - Complete database schema

Usage Examples

List all database connections

Read the database schema and show me all tables

Generate a query to find users who registered in the last 7 days

System Requirements

• VS Code / Cursor 1.80.0 or higher
• Node.js 18.0 or higher
• Java Runtime Environment (JRE) 11 or higher

Feedback & Support

• Report Issues: GitHub Issues
• Feature Requests: Request a Feature
• Ask Questions: Ask a Question

License

MIT License - see LICENSE.txt for details.

中文说明

功能特点

• 通用 JDBC 支持 - 支持所有 JDBC 兼容的数据库
• AI 集成 - 完整的 MCP 支持，可与 Cursor AI 智能交互
• 可视化浏览 - 树形视图浏览数据库结构
• SQL 执行 - 语法高亮和自动补全
• 自动驱动管理 - 自动下载和管理常用数据库驱动

快速上手

1. 安装扩展 - 在 Marketplace 搜索 "Reindeer DB"
2. 添加连接 - 点击侧边栏 + 按钮，填写数据库信息
3. 连接数据库 - 点击连接图标
4. 执行查询 - 创建 .sql 文件，按 F5 执行

MCP 自动配置

1. 打开项目，扩展会自动提示配置 MCP
2. 点击"Configure Now"（现在配置）
3. 自动创建配置文件
4. 重新加载 Cursor 即可使用

或使用命令：Reindeer DB: Generate MCP Configuration

支持的数据库

开源数据库: PostgreSQL, MySQL, MariaDB, H2, SQLite

商业数据库: Oracle, SQL Server, DB2, Sybase, Informix

国产数据库: 达梦(DM), 人大金仓(KingBase), 南大通用(GBase), 神舟通用(Oscar)

以及其他所有 JDBC 兼容的数据库

反馈与支持

• 报告问题: 提交 Issue
• 功能建议: 提交建议
• 使用问题: 提问

Made with ❤️ for developers who love databases and AI