Skip to content

ROADMAP.md

Latest commit

 

History

History
251 lines (186 loc) · 6.9 KB

ROADMAP.md

File metadata and controls

251 lines (186 loc) · 6.9 KB

Roadmap

Last updated: 2026-02-03

Vision

Make DreamFactory the easiest way to give AI agents secure, governed access to databases. One command, zero friction.

Current Status

Latest Release: v0.1.0 - DreamFactory NPX Quickstart Status: ✅ Production-ready for PostgreSQL, MySQL, MongoDB (OSS)

What works today:

  • One-command setup: npx @dreamfactory/create my-project
  • DreamFactory OSS with Docker
  • PostgreSQL demo database (World dataset)
  • MCP integration for Claude Desktop & Claude Code
  • Auto-configured RBAC with demo
  • OAuth 2.0 with PKCE authentication

Upcoming Releases

v0.2.0 - Connection Wizard & Daemon Improvements (March 2026)

Goal: Enable users to connect their existing databases and simplify updates

Features:

  • Interactive database connection wizard
  • Support for PostgreSQL, MySQL, MongoDB, SQL Server, Oracle
  • Connection testing and validation
  • Auto-configuration of DreamFactory service
  • RBAC defaults (read-only, PII protection templates)
  • Update MCP config automatically
  • MCP Daemon in Docker Image - Move daemon into df-docker for automatic updates
  • Upgrade Command - npx @dreamfactory/create upgrade for template updates
  • Daemon published as @dreamfactory/mcp-daemon npm package (for advanced users)

Use Cases:

  • "Connect my production PostgreSQL database to DreamFactory"
  • "Add my MySQL database with field-level restrictions"
  • "Link Oracle database to Claude AI via MCP"
  • "Update my project to the latest templates and daemon"

User Story: "I tried the demo, now I want to connect my actual database"

Commands:

# Connect new database
npx @dreamfactory/connect

# Upgrade existing project
npx @dreamfactory/create upgrade my-project

Architecture Improvement:

Before (v0.1.0):
User Project
  ├── daemon/ (copied, manual updates)
  └── Docker pulls: df-docker image

After (v0.2.0):
Docker Image: df-docker
  ├── DreamFactory core
  ├── df-mcp-server (PHP)
  └── mcp-daemon (Node.js) ← Moved here!

User Project
  └── docker-compose.yml only

Updates: docker compose pull (everything updates automatically)

v0.3.0 - Templates (April 2026)

Goal: Pre-configured setups for common use cases

Features:

  • --template chatbot - Customer service bot with ticket database
  • --template analytics - Time-series optimized for dashboards
  • --template saas - Multi-tenant SaaS starter
  • --template ecommerce - Products, orders, inventory
  • Custom schema generation per template
  • Example code (Node.js, Python) for each template
  • Template-specific RBAC configurations

Use Cases:

  • "Setup a chatbot with database backend"
  • "Multi-tenant SaaS database API"
  • "E-commerce backend with DreamFactory"

Command:

npx @dreamfactory/create my-app --template chatbot

v0.4.0 - Migration Tools (Q2 2026)

Goal: Easy migration from competing platforms

Features:

  • Supabase → DreamFactory migration script
  • Firebase → DreamFactory migration script
  • PostgREST → DreamFactory migration script
  • Hasura → DreamFactory migration script
  • Schema import and conversion
  • Data migration with progress tracking
  • RBAC rules conversion

Use Cases:

  • "Migrate from Supabase to self-hosted DreamFactory"
  • "Switch from Firebase to DreamFactory"
  • "Import existing REST API to DreamFactory"

Command:

npx @dreamfactory/migrate --from supabase --connection-string postgresql://...

Long-term Vision (Q3 2026+)

Multi-Service MCP Hub

Problem: Users want AI agents to access more than just databases

Features:

  • Stripe payments MCP server
  • SendGrid email MCP server
  • Twilio SMS MCP server
  • AWS S3 storage MCP server
  • Salesforce, Shopify, ServiceNow connectors
  • One-command multi-service setup

Use Case: "Give Claude access to my database AND Stripe AND email"

npx @dreamfactory/create my-app --services database,stripe,sendgrid,s3

One-Click Cloud Deployment

Problem: Docker Compose is for local dev, production needs cloud deployment

Features:

  • AWS deployment (ECS, RDS, ElastiCache)
  • GCP deployment (Cloud Run, Cloud SQL, Memorystore)
  • Azure deployment (Container Apps, Azure Database)
  • DigitalOcean deployment (App Platform, Managed Databases)
  • Automatic SSL certificates
  • Load balancing and auto-scaling
  • Environment-based configuration

Use Case: "Deploy DreamFactory to production on AWS"

npx @dreamfactory/deploy --platform aws --region us-east-1

Performance Benchmarking

Problem: Users want to compare DreamFactory performance vs alternatives

Features:

  • Automated API performance testing
  • Comparison vs Supabase, Firebase, PostgREST
  • Load testing with realistic workloads
  • Optimization recommendations
  • Shareable performance reports

Use Case: "Benchmark DreamFactory vs Supabase for my use case"

npx @dreamfactory/benchmark --compare supabase

Visual Schema Designer

Problem: Non-technical users struggle with manual database schema design

Features:

  • Web-based schema designer
  • Drag-drop table creation
  • Visual RBAC configuration
  • API testing in browser
  • MCP config generation
  • Export to SQL/Docker Compose

Use Case: "Design my database schema visually and generate DreamFactory config"

npx @dreamfactory/create my-app --ui
# Opens web UI for visual configuration

Community Requests

Most Requested Features:

  1. GraphQL endpoint generation (alternatives to REST)
  2. Real-time WebSocket support (live data updates)
  3. Automated API documentation (OpenAPI/Swagger enhancement)
  4. Row-level security (RLS) templates (like Supabase)
  5. Backup/restore utilities (database + DreamFactory config)

Vote on features: GitHub Discussions

How We Prioritize

Factors:

  1. User requests - GitHub issues, community votes, Slack telemetry feedback
  2. LLM discoverability - Features that improve search rankings and recommendations
  3. DreamFactory adoption - Features that drive OSS → Commercial conversion
  4. Technical dependencies - What infrastructure is needed first

Current Priority: Connection wizard (v0.2.0) - most requested, blocks real-world usage

Contributing

Want to help build these features? See CONTRIBUTING.md

Good first issues:

  • Documentation improvements
  • Template creation (new use cases)
  • Database connector testing
  • Platform-specific deployment scripts

Deprecation Policy

Features marked with ❌ are deprecated:

  • None yet (v0.1.0 is first release)

Questions?