DevDB - VS Code Extension
A comprehensive database and backend creation platform integrated directly into VS Code. Create production-ready databases, APIs, and deploy them instantly without leaving your editor.
🚀 Features
🗂️ Visual Schema Designer
- Drag-and-drop table creation
- Real-time schema visualization
- Field type management with validation
- Relationship mapping between tables
- SQL generation and export
⚡ Automatic API Generation
- REST API endpoints for all tables
- Multiple framework support (Node.js, Python, Go, Rust)
- Authentication middleware generation
- Input validation and error handling
- GraphQL schema generation (optional)
🔌 API Integration Wizard
- Stripe Payments - Accept payments, manage subscriptions
- Supabase Backend - Complete backend-as-a-service
- WebSocket Real-time - Live updates and messaging
- Twilio Communications - SMS, voice calls, verification
- Auth0 Authentication - Enterprise-grade auth
- AWS S3 Storage - Scalable cloud storage
- OpenAI GPT - AI-powered text generation
💾 Storage Management
- Storage Analysis - Monitor database usage and growth
- User Data Management - GDPR compliance and data retention
- Data Retention Policies - Automated cleanup and archiving
- Performance Optimization - Query optimization and indexing
🛡️ Security Management
- Vulnerability Scanning - Automated security assessments
- Penetration Testing - Exploit detection and prevention
- RBAC (Role-Based Access Control) - Granular permissions
- Encryption Configuration - Data protection at rest and in transit
- Audit Logging - Complete activity tracking
🔧 Advanced Database Management
- Multi-Database Connections - PostgreSQL, MySQL, MongoDB, Redis
- Database Replication - Master-slave configuration
- Horizontal Sharding - Scale across multiple databases
- Migration Management - Version-controlled schema changes
- Connection Pooling - Optimized database connections
🛡️ Built-in Authentication
- Multiple auth providers (Email, OAuth, SMS)
- JWT token management
- Two-factor authentication support
- Session management
- Security best practices
🚀 One-Click Deployment
- Multiple cloud providers (Vercel, Netlify, Railway, Heroku)
- Environment variable management
- Automatic SSL certificates
- CI/CD pipeline setup
- Monitoring and logging
📚 Auto-Generated Documentation
- Interactive API documentation
- Code examples in multiple languages
- SDK generation
- Postman collection export
- PDF documentation export
🔄 Database Development Lifecycle
- Planning Phase - Requirements gathering and ERD creation
- Design Phase - Schema design and optimization
- Development Phase - Migration scripts and stored procedures
- Testing Phase - Unit, integration, and performance testing
- Deployment Phase - Staging and production deployment
- Monitoring Phase - Performance monitoring and optimization
📦 Installation
- Open VS Code
- Go to Extensions (Ctrl+Shift+X)
- Search for "DevDB"
- Click Install
🚀 Quick Start
Create a New Project
- Open Command Palette (Ctrl+Shift+P)
- Type "DevDB: Create New Project"
- Choose your database type and framework
Design Your Schema
- Click on the DevDB icon in the Activity Bar
- Open Schema Designer
- Drag and drop tables and fields
Generate API
- Use "DevDB: Generate API" command
- Your REST endpoints are automatically created
Integrate APIs
- Open API Integration Wizard
- Select services like Stripe, Supabase, etc.
- Follow guided setup process
Manage Storage
- Analyze storage usage and growth
- Set up data retention policies
- Monitor GDPR compliance
Secure Your Application
- Run vulnerability scans
- Configure RBAC and encryption
- Set up audit logging
Deploy
- Choose your deployment provider
- Configure environment variables
- Deploy with one click
🎯 Commands
Core Commands
DevDB: Open Dashboard
- Open the main dashboard
DevDB: Create New Project
- Create a new database project
DevDB: Open Schema Designer
- Visual database design tool
DevDB: Generate API
- Auto-generate REST endpoints
DevDB: Setup Authentication
- Configure auth providers
DevDB: Deploy Project
- Deploy to production
API Integration
DevDB: Open API Integration Wizard
- Integrate popular APIs
DevDB: Integrate Stripe Payments
- Add payment processing
DevDB: Integrate Supabase Backend
- Add backend services
DevDB: Integrate WebSocket Real-time
- Add real-time features
Storage Management
DevDB: Analyze Storage Usage
- Monitor database storage
DevDB: Manage User Data
- GDPR compliance tools
DevDB: Setup Data Retention Policies
- Automated data lifecycle
Security
DevDB: Open Security Dashboard
- Security management center
DevDB: Run Vulnerability Scan
- Security assessment
DevDB: Configure Encryption
- Data protection setup
Advanced Database
DevDB: Open Advanced Database Management
- Database administration
DevDB: Setup Replication
- Configure master-slave replication
DevDB: Setup Sharding
- Horizontal database scaling
🛠️ Supported Technologies
Databases
- PostgreSQL
- MySQL
- MongoDB
- SQLite
- Redis
Backend Frameworks
- Node.js + Express
- Node.js + Fastify
- Python + FastAPI
- Python + Django
- Go + Gin
- Rust + Actix
API Integrations
- Stripe (Payments)
- Supabase (Backend)
- WebSockets (Real-time)
- Twilio (Communications)
- Auth0 (Authentication)
- AWS S3 (Storage)
- OpenAI (AI/ML)
Deployment Providers
- Vercel
- Netlify
- Railway
- Heroku
- DigitalOcean App Platform
- AWS Amplify
⚙️ Configuration
The extension can be configured through VS Code settings:
{
"devdb.defaultDatabase": "postgresql",
"devdb.defaultFramework": "node-express",
"devdb.autoGenerateAPI": true,
"devdb.enablePreviewMode": true,
"devdb.enableAPIIntegrations": true,
"devdb.enableDataRetention": true,
"devdb.gdprComplianceMode": true,
"devdb.enableSecurityScanning": true
}
📁 Project Structure
When you create a DevDB project, the following files are generated:
my-project/
├── devdb.config.json # Project configuration
├── devdb.schema.json # Database schema
├── devdb.phases.json # Development phases tracking
├── src/
│ ├── index.js # Main application file
│ ├── api/ # Generated API routes
│ ├── auth/ # Authentication middleware
│ ├── integrations/ # API integrations
│ └── security/ # Security configurations
├── migrations/ # Database migrations
├── tests/ # Database tests
├── scripts/ # Utility scripts
├── docs/ # Documentation
├── config/ # Configuration files
├── reports/ # Analysis reports
├── backups/ # Database backups
├── package.json # Dependencies
└── .env # Environment variables
🔧 Code Snippets
The extension includes helpful code snippets:
devdb-route
- Express.js route template
devdb-auth
- Authentication middleware
devdb-model
- Pydantic model (Python)
devdb-table
- SQL table creation
devdb-client
- API client class
devdb-integration
- API integration template
devdb-security
- Security configuration
devdb-migration
- Database migration template
🤝 Contributing
We welcome contributions! Please see our Contributing Guide for details.
📄 License
MIT License - see LICENSE file for details.
🆘 Support
Enjoy building with DevDB! 🚀
Transform your development workflow with comprehensive database and backend management, all within VS Code.
- Product management
- User accounts
- Payments
- Reviews
- Analytics
- Licensing