|
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.
|
By Nic Davidson
API managers are often used to expose REST APIs to an internal or external group of developers. An internal group of enterprise developers might use a catalog of API services as a starting point for software development projects. An external group of partners might use the APIs for integration with their backend systems. In some cases, partners might use the APIs to purchase goods, services, or information.
|
By Kevin Hood
Last Updated: May 2026 Asking the right questions when building an API for AI systems is critical, especially when updates risk breaking existing integrations. Here's the deal: API versioning ensures your AI workflows stay stable while introducing new features. By supporting multiple API versions, you can test updates, maintain compatibility, and avoid disruptions.
|
By Kevin Hood
Last Updated: May 2026 Oracle API Gateway (OAG), the product that grew out of Oracle's 2012 acquisition of Vordel, has been on a long deprecation path. With Oracle steering customers away from on-premises OAG and toward newer cloud-based offerings, technical decision makers are facing a familiar question: stay on a product without a future, or pick a replacement that fits where the business is actually going?
|
By Cody Lord
Last updated: May 2026 An API (Application Programming Interface) is a set of rules and definitions that lets one software system request data or services from another. APIs are the connective tissue of modern software — every time a mobile app shows live data, a website logs you in with Google, or a SaaS tool talks to your CRM, an API is doing the work in the background.
|
By Kevin Hood
Quick Takeaway: Governed APIs are better suited for AI workloads, offering enhanced security, better scalability, and compliance-friendly features. They prevent sensitive data exposure and protect databases from being overwhelmed by AI's unpredictable behavior.
|
By Nic Davidson
What the PocketOS incident reveals about AI agents, unscopped API tokens, and why enterprise data needs a gateway in front of it. DreamFactory is a secure, self-hosted enterprise data access platform that provides governed API access to any data source, connecting enterprise applications and on-prem LLMs with role-based access and identity passthrough.
|
By Kevin Hood
Schema validation ensures AI agents interact with APIs accurately by enforcing strict rules for requests and responses. OpenAPI provides a clear, machine-readable contract for APIs, reducing errors and improving reliability. This approach eliminates issues like ambiguous responses or schema drift, ensuring predictable behavior and secure data access.
|
By Kevin McGahey
DreamFactory 7.5.0 is focused on two audiences that have been growing fastest in our user base: teams wiring LLM agents to production databases through MCP, and security and platform teams hardening those deployments for real-world traffic.
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.
Most teams testing OpenAI’s new Agent Builder hit the same wall: connecting to their real enterprise data securely. In this 3-minute tutorial you’ll learn how to: DreamFactory MCP bridges the gap so you can move from demo to production-ready agent on real data — fast, secure, and with no new infrastructure. Deploy locally: npx @dreamfactory/create-df-mcp.
In this No Code API Tutorial, you’ll learn how to build a secure REST API in 2 steps using DreamFactory — no coding required. This tutorial shows how to instantly generate a database API for your data products or front-end applications, saving you days or even weeks of development time. Here’s what you’ll discover in this step-by-step guide: How to connect to any SQL or NoSQL database instantly How to configure database API access (full access, schema access, table access, stored procedures, and functions)
In this 5-minute demo, we use DreamFactory’s MCP server with Claude Code and Claude Desktop to: This isn’t AI writing SQL. This is AI orchestrating secure APIs—fast, safe, and auditable. DreamFactory MCP is the secure API gateway that turns databases into AI-ready endpoints—with RBAC, parameterization, and audit logging built-in.
In this video, Terence demos how combining DreamFactory's MCP server and Claude code you can securely expose your data schema and allow Claude code to then generate bespoke MCP servers based on your data. This allows you to get the upside of using AI code editors like Claude Code while keeping your data secure.
In this No Code API Tutorial, you’ll learn how to build a secure REST API in less than 5 minutes using DreamFactory — no coding required. This tutorial shows how to instantly generate a database API for your data products or front-end applications, saving you days or even weeks of development time. Here’s what you’ll discover in this step-by-step guide: How to connect to any SQL or NoSQL database instantly.
This brief demo outlines how DreamFactory automatically inspects the schema of any database API created, enabling a wide range of data mesh activities, such as merging tables and joining data across disparate databases using virtual joins. This significantly reduces development time and ensures data consistency across your entire data landscape.
|
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).
- May 2026 (6)
- April 2026 (17)
- March 2026 (20)
- February 2026 (15)
- January 2026 (21)
- 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 (11)
- February 2025 (4)
- January 2025 (11)
- December 2024 (19)
- November 2024 (7)
- October 2024 (8)
- September 2024 (9)
- August 2024 (10)
- July 2024 (11)
- June 2024 (8)
- May 2024 (8)
- 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.