|
By Nic Davidson
A BigQuery MCP server lets AI agents like Claude query your Google BigQuery data through a standard protocol instead of ad-hoc integrations. Because BigQuery bills by bytes scanned, an unconstrained agent is not just a security risk but a budget risk: one careless full-table scan on a wide table costs real money. This guide covers what a BigQuery MCP server does, the three ways to set one up, and the cost and security controls that matter before you let an agent anywhere near your analytics data.
|
By Kevin Hood
Every utility is being pulled in two directions. Operations, engineering, and customer-facing teams all want data in modern applications: outage maps, field-service apps, asset-health dashboards, regulator reporting, and increasingly AI assistants that can answer questions about generation, load, or maintenance history. At the same time, the security team's job is to make sure none of that convenience becomes a path into systems that open spillway gates, trip breakers, or control pressure.
|
By Nic Davidson
Auto-generated APIs changed how fast teams ship. Point DreamFactory at a database and you get a complete REST API in seconds: every table, full CRUD, live documentation, role-based security. For thousands of teams, that is the whole job. But auto-generated APIs mirror your schema. Your applications, and increasingly your AI agents, want something more deliberate: clean paths, shaped responses, and endpoints that match how the consumer thinks rather than how the database is laid out.
|
By Kevin Hood
Every school, college, and university is being asked the same question right now: Can we use AI on our own data without putting student records at risk? The promise is real, including personalized learning, faster advising, and smarter operations. So is the fear. AI that touches student information runs straight into FERPA, breach risk, and a simple trust problem: once data leaves your control, you can't govern it.
|
By Kevin McGahey
Last updated: May 2026 Stateful applications remember information about previous client interactions. Stateless applications treat every request as independent — no memory between calls. The choice between these two designs shapes how an application scales, how it handles failures, and increasingly how AI agents consume it.
|
By Susanna Bouse
RESTful APIs and microservices solve different problems — REST is a style of API design, microservices is a pattern for structuring an application — but they work together so often that they're frequently confused. Most production microservices architectures use REST as the default communication mechanism between services, while plenty of monolithic applications also expose RESTful APIs to external clients.
|
By Nic Davidson
Last updated: May 2026 An Oracle MCP server is a service that exposes Oracle Database data as tools an AI agent can call through the Model Context Protocol (MCP). Rather than handing an LLM direct credentials to a database holding ERP, financial, or healthcare records, you put an MCP server between the agent and Oracle.
|
By Cody Lord
Last updated: May 2026 A Snowflake MCP server is a service that exposes Snowflake warehouses as tools an AI agent can call through the Model Context Protocol (MCP). It sits between AI clients like Claude or ChatGPT and your Snowflake data, translating discoverable tool calls into governed SQL — with row access policies, dynamic data masking, query budgets, and audit logging applied automatically.
|
By Kevin Hood
Last updated: May 2026 A PostgreSQL MCP server is a service that exposes PostgreSQL databases as tools an AI agent can call through the Model Context Protocol (MCP). Rather than giving an LLM direct database credentials, you put an MCP server between the agent and the database. The agent discovers what queries it can run, calls them as named tools, and the MCP server translates those calls into safe, governed SQL against PostgreSQL.
|
By Terence Bennett
Last Updated: May 2026 Your API documentation is just as important as your API itself. It defines how easy it is for users to learn, understand, and use your open-source or paid product. In this post, DreamFactory highlights eight of the best API documentation examples from well-known tools. These examples can serve as inspiration for creating effective, developer-friendly API documentation.
DreamFactory 7.7 is out. Agents have owners. API Builder is new. Schema Contracts lock the shape. The admin console is new. Four things that shipped: Agent governance. Every agent has a human owner, a role, and a key that expires in four hours. Deactivate the owner and the agent stops. API Builder. Design the endpoint the app actually wants. Custom paths, shaped responses, on services you already have. Open source, in every edition.
A walk through demo video of the DreamFactory data explorer.
Walk through of the new API Builder available in DreamFactory v7.7.
Getting data out of source systems and into the applications that need it is usually slow, custom, and hard to secure. Today I'll show you how DreamFactory solves that as a secure data gateway. This demo today is based on a government healthcare use case.
Turn a Google BigQuery project into a secured REST API without putting the warehouse credential in your app. DreamFactory stores the service account. Your app calls a URL with an API key. Role-based access control decides what that key can see. Docs are generated from the live spec, so fields and filters become query parameters you can ship. In this walkthrough.
Getting data out of source systems and into the applications that need it is usually slow, custom, and hard to secure. Today I'll show you how DreamFactory solves that as a secure data gateway. This demo today is based on a government healthcare use case.
What if you could ask ChatGPT "which customers haven't ordered in 90 days?" and get an instant answer from your SQL Server database? I set this up live in under 5 minutes. No code. No SQL. Just questions and answers.
What if you could ask Claude "which customers haven't ordered in 90 days?" and get an instant answer from your SQL Server database? I set this up live in under 5 minutes. No code. No SQL. Just questions and answers.
What if you could ask ChatGPT "which customers haven't ordered in 90 days?" and get an instant answer from your actual database? I set this up live in under 5 minutes. No code. No SQL. Just questions and answers.
In this Tutorial, you’ll learn how to build a secure REST API using Role Based Access Control Here’s what you’ll discover in this step-by-step guide: How to configure database API access (full access, schema access, table access, stored procedures, and functions) How to apply enterprise-grade security with API keys and role-based access control (RBAC) How to support multi-tenant scenarios with RBAC that supports record or row level security.
|
By DreamFactory
The exploding complexity of backend interfaces is a real problem for companies building mobile and web applications or just using REST API services.
|
By DreamFactory
Containers and microservices are redefining the software development lifecycle. Developers are empowered to choose best of the breed languages, frameworks, and runtimes to develop software. DevOps teams are dealing with new packaging and deployment mechanisms. Container orchestration tools such as Docker Swarm, Kubernetes, Apache Mesos are changing the way applications are deployed and managed.
|
By DreamFactory
DreamFactory is a configurable LAMP stack running PHP. As far as the server is concerned, DreamFactory looks like a website written in WordPress or Drupal. Instead of delivering HTML pages, DreamFactory provides JSON documents, but otherwise, the scaling requirements are similar.
|
By DreamFactory
Large enterprise and government organizations often inquire about how the DreamFactory REST API platform helps secure data access. Especially now that a growing number of web and mobile apps need to access sensitive data, and proper controls are imperative in the services used to access that data from an expanding number of apps.
|
By DreamFactory
Serverless Computing is considered to be the fourth wave of computing where x86 servers, virtual machines, and containers represented the first three generations. With this new paradigm, developers can squarely focus on the code and without the need to deal with the underlying infrastructure. They never have to plan the number of servers, amount of storage, and the network topology of deployments. Since the platform deals with one function at a time, and functions are the fundamental deployment units, this model is often called Functions as a Service (FaaS).
- August 2026 (10)
- May 2026 (10)
- April 2026 (17)
- March 2026 (20)
- February 2026 (15)
- January 2026 (23)
- December 2025 (9)
- November 2025 (14)
- October 2025 (18)
- September 2025 (21)
- August 2025 (25)
- July 2025 (26)
- June 2025 (16)
- May 2025 (17)
- April 2025 (12)
- March 2025 (10)
- February 2025 (4)
- January 2025 (11)
- December 2024 (18)
- November 2024 (7)
- October 2024 (8)
- September 2024 (9)
- August 2024 (10)
- July 2024 (10)
- June 2024 (8)
- May 2024 (7)
- April 2024 (12)
- March 2024 (9)
- February 2024 (13)
- January 2024 (17)
- December 2023 (8)
- November 2023 (8)
- October 2023 (15)
- September 2023 (12)
- August 2023 (13)
- July 2023 (9)
- June 2023 (8)
- May 2023 (4)
- April 2023 (6)
- March 2023 (5)
- February 2023 (7)
- January 2023 (9)
- December 2022 (7)
- November 2022 (3)
- October 2022 (6)
- September 2022 (7)
- August 2022 (12)
- July 2022 (6)
- June 2022 (7)
- May 2022 (9)
- April 2022 (10)
- March 2022 (13)
- February 2022 (12)
- January 2022 (14)
- December 2021 (5)
- November 2021 (8)
- October 2021 (8)
- September 2021 (7)
- August 2021 (9)
- July 2021 (11)
- June 2021 (10)
- May 2021 (16)
- April 2021 (10)
- March 2021 (11)
- February 2021 (14)
- January 2021 (13)
- December 2020 (15)
- November 2020 (5)
- October 2020 (2)
- September 2020 (4)
- August 2020 (3)
- July 2020 (4)
- June 2020 (11)
- May 2020 (10)
- April 2020 (8)
- March 2020 (2)
- February 2020 (2)
- January 2020 (3)
- December 2019 (4)
- November 2019 (4)
- October 2019 (4)
- August 2019 (5)
- July 2019 (1)
- May 2019 (1)
- March 2019 (1)
- February 2019 (1)
- January 2019 (1)
- June 2018 (2)
- April 2017 (1)
- March 2017 (1)
Never Build an API Again. An enterprise-grade API as a service platform available in the cloud or on-premise. Generate database APIs instantly to build applications faster.
Integrate any SQL or NoSQL database, file storage system, or external HTTP or SOAP service and DreamFactory instantly generates a flexible, comprehensive, and fully documented REST API endpoint that’s ready to use. Focus on building your applications, not hand-coding APIs for every new development project.
Benefits:
- Instant APIs without code. Eliminate the biggest bottleneck in modern IT. Launch your project in weeks rather than months. DreamFactory instantly creates a secure, standardized, reusable, fully documented, and live REST API.
- Manage your data portfolio. Connect Salesforce to SQL Server, or your ERP to AWS S3. Transform and mask data along the way. Create reports, analytics, and alerts. Empower teams to retrieve and distribute data on demand.
- Secure your data with layered controls. Secure every API endpoint with Role-Based Access Controls, SSO Authentication, JWT, CORS, OAuth, and Active Directory. Deploy behind firewalls and in air-gapped environments.
- Modernize legacy applications. Integrate legacy technology into cutting-edge applications, extending technology lifecycles and derisking legacy system replacements.
REST API Automation and API Management made simple.