Sign inSign up

intraqdev/ai-pipeline-builder-backend

By intraqdev

•Updated 6 months ago

ai-pipeline-builder-backend

Image
0

6.6K

intraqdev/ai-pipeline-builder-backend repository overview

⁠AI Pipeline Builder Backend API

AI Pipeline Builder Logo

AI-powered pipeline builder and analytics platform - Backend API Server

⁠🚀 Quick Start

# Simple deployment with PostgreSQL
docker run -d --name postgres \
  -e POSTGRES_DB=ai_insights \
  -e POSTGRES_USER=ai_user \
  -e POSTGRES_PASSWORD=secure_pass \
  -p 5432:5432 \
  postgres:15-alpine

docker run -d --name ai-insights-backend \
  -p 5000:5000 \
  -e DATABASE_URL=postgresql://ai_user:secure_pass@postgres:5432/ai_insights \
  -e JWT_SECRET=your-super-secure-jwt-secret-key \
  -e SUBSCRIPTION_KEY=your-subscription-key \
  --link postgres:postgres \
  your-username/ai-insights-backend:latest

# API available at http://localhost:5000

⁠🏗️ What is AI Insights Backend?

The AI Insights Backend is a powerful Node.js API server that provides:

  • 🔐 Authentication & Authorization - JWT-based security with subscription control
  • 📊 Data Source Management - Connect to 15+ database types
  • 🔧 Data Pipeline Engine - Execute complex data transformations
  • 🤖 AI Integration - OpenAI-powered natural language processing
  • 📈 Analytics Engine - Real-time data processing and insights
  • 🎨 Multi-tenant Architecture - Secure, isolated customer environments

⁠🔧 Configuration

⁠Required Environment Variables
# Database (Required)
DATABASE_URL=postgresql://user:password@host:5432/database

# Security (Required)
JWT_SECRET=your-secure-jwt-secret-minimum-32-characters
ENCRYPTION_KEY=your-exactly-32-character-encryption-key

# Subscription (Required)
SUBSCRIPTION_KEY=your-subscription-jwt-token
SUBSCRIPTION_SECRET=your-subscription-secret
⁠First-time Setup
# Admin User Creation
FIRST_TIME_SETUP=true
[email protected]
ADMIN_PASSWORD=secure-admin-password

# Company Branding
COMPANY_NAME=Your Company Name
LOGO_URL=https://your-domain.com/logo.png
PRIMARY_COLOR=#3b82f6
⁠Supported Data Sources
  • Relational: PostgreSQL, MySQL, SQL Server, Oracle
  • Cloud: AWS RDS, Google Cloud SQL, Azure SQL
  • Analytics: Databricks, Snowflake, BigQuery, Redshift
  • NoSQL: MongoDB, DynamoDB
  • Files: S3, CSV, JSON, Parquet
  • APIs: REST APIs, GraphQL

⁠🐳 Docker Usage

⁠Basic Deployment
docker run -d \
  --name ai-insights-backend \
  -p 5000:5000 \
  -e DATABASE_URL=postgresql://user:pass@host:5432/db \
  -e JWT_SECRET=your-jwt-secret \
  -e SUBSCRIPTION_KEY=your-subscription-key \
  your-username/ai-insights-backend:latest
⁠With External PostgreSQL
docker run -d \
  --name ai-insights-backend \
  -p 5000:5000 \
  -e DATABASE_URL=postgresql://user:pass@your-db-host:5432/ai_insights \
  -e JWT_SECRET=your-super-secure-jwt-secret-key \
  -e ENCRYPTION_KEY=your-32-character-encryption-key \
  -e SUBSCRIPTION_KEY=your-subscription-jwt-token \
  -e SUBSCRIPTION_SECRET=your-subscription-secret \
  -e FIRST_TIME_SETUP=true \
  -e [email protected] \
  -e ADMIN_PASSWORD=secure-password \
  your-username/ai-insights-backend:latest
⁠Docker Compose
version: '3.8'
services:
  postgres:
    image: postgres:15-alpine
    environment:
      POSTGRES_DB: ai_insights
      POSTGRES_USER: ai_user
      POSTGRES_PASSWORD: secure_pass
    volumes:
      - postgres_data:/var/lib/postgresql/data

  backend:
    image: your-username/ai-insights-backend:latest
    ports:
      - "5000:5000"
    environment:
      - DATABASE_URL=postgresql://ai_user:secure_pass@postgres:5432/ai_insights
      - JWT_SECRET=your-jwt-secret
      - SUBSCRIPTION_KEY=your-subscription-key
    depends_on:
      - postgres

volumes:
  postgres_data:

⁠📊 API Endpoints

⁠Core APIs
  • GET /api/health - Health check and status
  • POST /api/auth/login - User authentication
  • GET /api/data-sources - List data sources
  • GET /api/dashboards - List dashboards
  • GET /api/pipelines - List data pipelines
⁠Advanced APIs
  • POST /api/ai/query - AI-powered queries
  • GET /api/admin/users - User management
  • GET /api/embed/dashboard/:id - Embedded dashboards

⁠🏥 Health Monitoring

# Basic health check
curl http://localhost:5000/api/health

# Detailed readiness check
curl http://localhost:5000/api/ready

# Subscription status
curl -H "X-Subscription-Key: your-key" http://localhost:5000/api/subscription

⁠🔄 Database Migrations

Automatic database setup on first run:

  • Creates all required tables
  • Sets up initial admin user
  • Configures default settings
  • Seeds sample data (optional)

⁠📈 Performance Features

  • Connection Pooling - Optimized database connections
  • Caching - Redis-based response caching
  • Async Processing - Background job processing
  • Load Balancing - Horizontal scaling support

⁠🔒 Security Features

  • Subscription Validation - JWT-based license verification
  • Feature Access Control - Granular permission system
  • Data Encryption - AES-256 encryption for sensitive data
  • Rate Limiting - API request throttling
  • Audit Logging - Comprehensive activity tracking

⁠📖 Documentation

⁠🏷️ Available Tags

  • latest - Latest stable release (recommended)
  • v1.x.x - Specific version releases
  • dev - Development builds (not for production)

⁠🔄 Updating

# Update to latest version
docker pull your-username/ai-insights-backend:latest
docker stop ai-insights-backend
docker rm ai-insights-backend
# Run with new image (automatic migration)

⁠🆘 Support

⁠📄 Licensing

This software requires a valid subscription license from AI Insights. Each deployment must include a valid SUBSCRIPTION_KEY.

⁠Getting Started
  1. Contact Sales: [email protected]⁠
  2. Receive Subscription Key: JWT token with your features
  3. Deploy: Use the subscription key in your environment
  4. Activate: First-time setup creates your admin account

Ready to get started? Contact us at [email protected]⁠ for your subscription key!

Tag summary

Content type

Image

Digest

sha256:55905bd31…

Size

839.7 MB

Last updated

6 months ago

docker pull intraqdev/ai-pipeline-builder-backend