🎯 Live Database Playground

🚀 Features

🔌 Multi-Database Support

💡 AI-Powered Query Generation

Write natural language comments and let AI generate the perfect query:

// db: get all users with age greater than 25
// Press Ctrl+Shift+G to generate: SELECT * FROM users WHERE age > 25

⚡ Inline Query Execution

Execute queries directly from your code with instant results:

SELECT * FROM users WHERE status = 'active';

🎯 Smart IntelliSense

📊 Beautiful Results Display

🔄 Query History

🛠️ Installation

From VSIX (Recommended)

1. Download the latest .vsix file from releases
2. In VS Code, go to Extensions (Ctrl+Shift+X)
3. Click the "..." menu and select "Install from VSIX..."
4. Choose the downloaded file

From Source

git clone https://github.com/ZainulabdeenOfficial/Live_Database_VSCode_Extention.git
cd Live_Database_VSCode_Extention
npm install
npm run compile

⚙️ Configuration

Database Connections

1. Open Command Palette (Ctrl+Shift+P)
2. Run "Live DB: Connect to Database"
3. Follow the connection wizard
4. Save connections for future use

AI Query Generation

1. Get an OpenAI API key from OpenAI
2. Open VS Code Settings (Ctrl+,)
3. Search for "Live Database Playground"
4. Enter your API key in liveDB.openaiApiKey

🎮 Usage

Quick Start

1. Connect to Database: Ctrl+Shift+P → "Live DB: Connect to Database"
2. Write a Query: Add a comment like // db: get all users
3. Generate SQL: Press Ctrl+Shift+G to generate the query
4. Execute Query: Press Ctrl+Shift+Q to run and see results

Natural Language Queries

// db: find all active users who signed up in the last 30 days
// db: count total orders by customer
// db: get the top 10 products by sales

Direct SQL Execution

SELECT u.name, COUNT(o.id) as order_count
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
WHERE u.status = 'active'
GROUP BY u.id, u.name
ORDER BY order_count DESC;

MongoDB Queries

// db: find all users with age greater than 25
db.users.find({ age: { $gt: 25 } })

// db: aggregate orders by month
db.orders.aggregate([
  { $group: { _id: { $month: "$date" }, total: { $sum: "$amount" } } }
])

⌨️ Keyboard Shortcuts

🎨 UI Components

Activity Bar

Inline Features

🔧 Advanced Features

Connection Management

Query Optimization

Export & Sharing

🐛 Troubleshooting

Connection Issues

1. Verify database server is running
2. Check firewall settings
3. Ensure correct credentials
4. Try SSL connection if needed

AI Generation Issues

1. Verify OpenAI API key is set
2. Check internet connection
3. Ensure sufficient API credits
4. Try rule-based generation as fallback

Performance Issues

1. Limit result set size in settings
2. Use pagination for large datasets
3. Optimize queries before execution
4. Check database server performance

🤝 Contributing

We welcome contributions! Please see our Contributing Guide for details.

Development Setup

git clone https://github.com/ZainulabdeenOfficial/Live_Database_VSCode_Extention.git
cd Live_Database_VSCode_Extention
npm install
npm run watch

Testing

npm test
npm run lint

📁 Repository

GitHub Repository: https://github.com/ZainulabdeenOfficial/Live_Database_VSCode_Extention

📊 Repository Stats

• Language: TypeScript (91.3%), JavaScript (8.7%)
• Stars:
• Forks:
• Issues:

🔗 Quick Links

• VS Code Marketplace: Live Database Playground
• Publisher: mzainulabideen
• Documentation: README.md

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

🙏 Acknowledgments

📞 Support

Made with ❤️ for the developer community