Skip to content

Releases: mahiiyh/sqlpulse

🚀 SQLPulse v1.0.0 - Initial Release

Choose a tag to compare

@mahiiyh mahiiyh released this 04 Feb 19:19

🎉 Welcome to SQLPulse!

SQLPulse is a comprehensive SQL query management and automation platform designed for database administrators, analysts, and developers.

✨ Key Features

🔐 Authentication & Security

  • User registration and login system
  • JWT-based authentication
  • Role-based access control (RBAC)
  • AES-256 encrypted credential storage
  • Rate limiting and security hardening

📚 Query Management

  • Full-featured SQL editor with Monaco (VS Code editor)
  • Query library with search and categorization
  • 20+ pre-made query templates for common tasks
  • Support for PostgreSQL, MySQL, and SQL Server
  • Parameter support with variable placeholders

⏰ Scheduling & Automation

  • Schedule queries with cron expressions
  • Multiple schedule types (one-time, daily, weekly, monthly, hourly, custom)
  • Visual cron expression builder
  • Timezone support for global teams
  • Retry logic with exponential backoff

🔌 Multi-Database Support

  • SQL Server (MSSQL)
  • MySQL
  • PostgreSQL
  • Secure connection management
  • Environment tagging (Dev, QA, UAT, Production)

📊 Monitoring & Analytics

  • Real-time execution dashboard
  • Execution history and audit trail
  • Performance analytics and trends
  • Live job monitoring
  • Success/failure tracking

👥 Team Collaboration

  • Team-based query sharing
  • Role management within teams
  • Team invitations and member management
  • Shared query templates

🔔 Notifications

  • Email notifications (SMTP)
  • Slack, Microsoft Teams, Discord integration
  • Webhook support
  • Configurable triggers (success, failure, conditions)

🛠️ Technology Stack

Frontend:

  • React 18 with TypeScript
  • Tailwind CSS for styling
  • Monaco Editor for SQL editing
  • Zustand for state management

Backend:

  • Node.js with Express
  • TypeScript
  • Sequelize ORM
  • JWT authentication
  • Bull queue with Redis

Database:

  • PostgreSQL 14+
  • Redis 7+

🚀 Deployment

This release includes:

  • Production-ready Docker setup
  • Automated CI/CD pipeline
  • Environment-based configuration
  • Comprehensive logging and monitoring

📚 Documentation

🔒 Security

  • See SECURITY.md for security best practices
  • Report security vulnerabilities responsibly (see SECURITY.md)

🤝 Contributing

Contributions are welcome! See CONTRIBUTING.md

📄 License

MIT License - see LICENSE


Live Demo: https://sqlpulse.mahiiyh.me

Made with ❤️ for database professionals