DreamFactory v7.4.2 delivers a new Data Explorer for visual database browsing, expands MCP server capabilities with multi-API and file support, introduces Google Workspace group-to-role mapping, and improves PostgreSQL stored procedure handling.

New Features

Data Explorer

• New admin UI feature — Browse database tables, view schema details, filter and search data, navigate foreign key relationships, and inspect row details directly from the API Connections section of the admin panel
• Schema tree navigation with table and column visibility
• Built-in filtering and foreign key link navigation for exploring related data

MCP Server Multi-API & File Support

• Multi-API connector support — MCP server is no longer limited to a single API; connect AI agents to multiple DreamFactory services simultaneously
• File API tools — AI agents can now interact with DreamFactory's file management services through MCP
• OAuth discovery — Added RFC 8414 .well-known URI support for standard OAuth server metadata discovery
• Claude Desktop fix — Resolved OAuth Dynamic Client Registration (DCR) compatibility issue for Claude Desktop MCP integration

Google Workspace Group-to-Role Mapping

• Map Google Workspace groups directly to DreamFactory roles using the Google Admin SDK
• New map_group_to_role toggle in OAuth configuration for Google providers
• Automatic group resolution and role assignment during SSO login
• New role_google database table for managing group-to-role mappings

OAuth & Authentication Fixes

• Fixed Azure AD / Entra ID UI page being incorrectly overwritten by the generic OAuth UI
• Resolved incorrect field population for OAuth providers on the Authentication configuration page

Database Connectors

PostgreSQL

• Stored procedure & function fixes — Improved compatibility with PostgreSQL v12+ when invoking stored procedures and functions
• Added SELECT * fallback when field resolution fails during procedure execution

SQL Database (General)

• Virtual relationship transactions — Virtual relationship operations are now wrapped in proper database transactions via RelationTransactionContext, ensuring data consistency across related table operations
• Updated df-database dependency across all database connector packages for improved compatibility

Upgrade Notes

• MCP server users: The api_name column has been removed from the MCP server configuration table in favor of the new multi-API architecture. Existing MCP configurations will need to be reconfigured to specify connected APIs through the updated interface.
• Google OAuth users: A new database migration adds the map_group_to_role column and role_google table. Run php artisan migrate after upgrading.
• Standard upgrade process applies for all other changes.