Web Application
Business Intelligence Tools
Overview
Business Intelligence Tools is a modular React + Express.js platform providing specialized internal tools for data management, customer analytics, and operational automation. Built for secure team access over SSH-tunneled connections to production databases, it enables marketing and operations teams to extract business-critical data without direct database access. The system uses n8n for background processing and features an extensible plugin-style architecture for adding new tools.
Key Features
- Customer search engine: find buyers by Product ID, SKU, Barcode, or product title
- CSV export and one-click email list copy for marketing campaigns
- SSH tunnel manager for secure remote MySQL database access
- Backend REST API with JWT authentication and rate limiting
- n8n workflow integration for background data processing jobs
- Product catalog browser with stock and pricing analytics
- User management with team-based permission scoping
- Audit log for all data export and search operations
- Dark-mode responsive UI built with TailwindCSS
- Webhook endpoint for receiving n8n workflow results
Highlights
- Enables marketing team to self-serve customer data without DBA involvement
- SSH tunnel ensures zero exposure of production database credentials
- Modular plugin architecture allows adding new tools in under 2 hours
- Processes 500+ customer export requests per week
- Full audit trail ensures GDPR-compliant data access logging
Technology Stack
React 18Express.jsMySQLn8nNode.jsTailwindCSSJWTSSH2Docker