sqllens.ai

Advanced MySQL GUI for Visual Studio Code with query optimization, debugging, and performance analysis.

Note: sqllens.ai is a fork of vscode-database-client by Weijan Chen, focused exclusively on MySQL with enhanced features. See ATTRIBUTION.md for details.

Features

🚀 Current Features (v0.1.0 Alpha)

Connection Management: Add, edit, and delete MySQL connections with secure password storage
Database Explorer: Browse databases, tables, and columns in a tree view
Secure Storage: Passwords stored securely using VS Code's secrets API
Connection Pooling: Efficient connection management with automatic pooling

🔮 Coming Soon

Query Execution: Execute SQL queries with beautiful results display
Query Optimizer: AI-powered query optimization with index recommendations
On-Demand Debugger: Real-time performance monitoring and debugging
Lock Detection: Visual lock chain and deadlock detection
Slow Query Analyzer: Batch analysis of slow query logs
Visual Query Builder: Drag-and-drop query building

Installation

From Source (Development)

Clone the repository:

git clone https://github.com/yourusername/skylinemysql.git
cd skylinemysql

Install dependencies:
```
npm install
```
Compile the extension:
```
npm run compile
```
Press F5 to launch the extension in a new VS Code window

Usage

Adding a Connection

Click the "+" icon in the sqllens.ai sidebar
Enter connection details:
- Connection Name
- Host (e.g., localhost)
- Port (default: 3306)
- Username
- Password
- Default Database (optional)
The connection will be tested before saving

Browsing Databases

Expand a connection in the tree view
Browse databases, tables, and columns
View column metadata (type, nullable, keys)

Requirements

Visual Studio Code 1.85.0 or higher
MySQL 5.7+ or MySQL 8.0+
Node.js 18+ (for development)

Development

Project Structure

src/
├── extension.ts              # Main entry point
├── managers/
│   └── connectionManager.ts  # Connection management
├── providers/
│   └── databaseTreeProvider.ts # Tree view provider
└── types/
    └── connection.ts         # TypeScript interfaces

Building

npm run compile

Testing

npm test

Debugging

Press F5 in VS Code to launch the extension in debug mode.

Roadmap

See skylinemysql.md for the complete 12-week development plan.

Phase 1: Foundation (Weeks 1-4) ✅ In Progress

[x] Connection management
[x] Database tree explorer
[ ] Query execution
[ ] Results display
[ ] Query favorites & history

Phase 2: Advanced Features (Weeks 5-8)

[ ] Visual query builder
[ ] Query optimizer
[ ] On-demand debugger

Phase 3: Problem Solvers (Weeks 9-12)

[ ] Lock & deadlock detector
[ ] Normalization checker
[ ] Slow query log analyzer

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

Documentation

Integration & Attribution

Integration Summary - Overview of fork and features
Quick Reference - Quick facts and FAQ
Code Comparison - Detailed code comparison
Full Integration Details - Complete documentation
Attribution - Legal attribution and acknowledgments

Technical Documentation

Fixes Complete - Bug fixes and improvements
Migration Plan - Development roadmap

License

MIT License - see LICENSE file for details

Dual Copyright:

Acknowledgments

sqllens.ai is based on vscode-database-client by Weijan Chen.

We are deeply grateful to Weijan Chen for creating the excellent vscode-database-client extension, which serves as the foundation for sqllens.ai. The original extension has over 2 million installs and is widely used by developers worldwide.

See ATTRIBUTION.md for complete attribution details.

Support

Website: skylineai.app
Email: hello@skylineai.app
Repository: github.com/sudheer2000/skylinemysql
Issues: Report bugs or request features
Original Project: vscode-database-client

Note: This extension is a fork of vscode-database-client, focused exclusively on MySQL with enhanced features. Currently in active development.

SQLLens.AI

skylineai