Systems | Development | Analytics | API | Testing

In this demo, I wire together a new DreamFactory API exposing SQLServer, the DreamFactory MCP Server, Claude Desktop, and Canva to interrogate some new data and them make charts out of it.

In this short video, I walk through how the Claude Code and the DreamFactory MCP server work together to ensure compliance and security.

In this MCP Tutorial, you’ll learn how to securely connect any database using Claude Desktop and the DreamFactory AI Data Gateway (MCP server). This step-by-step guide shows how to integrate MCP with Claude to streamline data access while applying enterprise-grade security controls. What you’ll discover in this tutorial: How to use Claude Desktop with DreamFactory MCP to connect to SQL & NoSQL databases.

How can I securely connect an LLM to my database?! Get ready to unlock the full power of AI with DreamFactory’s upcoming AI Data Gateway! This new capability empowers teams to securely expose data to AI clients, tools, and agents—without sacrificing enterprise-grade control. RBAC-protected dataset access Fine-grained, zero-trust data exposure Seamless integration with OpenAI, Claude, LangChain & more Machine learning-ready APIs with instant insight delivery.

In this short demo, I walk through how DreamFactory acts as a data AI gateway by applying RBAC to an existing database and allowing you to map specific data access with roles that then map to agents or chatbots. We think this is a missing approach to exposing proprietary or production data to AI systems.

In this live demonstration, DreamFactory's CTO walks us through creating a secure access layer for LLMs to communicate with our databases. This innovative way of exposing data via MCP and robust RBAC policies ensures AI is not able to reach any of your sensitive data.

Watch how DreamFactory's MCP Server allows for natural language queries of your direct database with a high level of accuracy. Additionally, RBAC ensures data governance by making sure only the correct data is exposed to certain users based on their roles.

API for Snowflake with no-code required. Instantly generate a fully documented and secure REST API for Snowflake as an alternative to the Snowflake REST API and Snowflake SQL API.

In this webinar, Kevin McGahey, CTO of DreamFactory, discusses how you can use DreamFactory to autogenerate REST APIs for Apache Iceberg, allowing users to directly interact with their Iceberg data through Snowflake.