Topic

SQL

All digests tagged SQL

What Are Large Database Models? AI for SQL Data thumbnail

· 13:55

What Are Large Database Models? AI for SQL Data

Large Database Models (LDMs) represent a significant advancement in applying AI to enterprise data by bringing semantic capabilities directly into SQL and relational databases. Unlike Large Language Models (LLMs), which train on general text, LDMs are trained specifically on selected tables or views within a structured database. This allows organizations to unlock the estimated 99% of critical business data—often locked behind encryption and access controls—without needing to move it.

Key takeaways

  1. LDM Functionality vs. Traditional SQL 2:15

    Traditional methods require data scientists to manually write rigid SQL filters (e.g., `where age is between 20 and 40`) and move data to an analytics platform, which is slow and expensive. LDMs use vector representations learned from co-occurring values across columns to perform semantic queries, eliminating the need for manual field selection or guessing constraints.

  2. Core LDM Capabilities 3:30

    LDMs enable advanced querying capabilities such as finding customer similarity (finding customers 'most similar' to a given ID), identifying unusual transactions (fraud detection), and exploring product relationships, all executed via standard SQL against the database itself.

  3. Commercial Availability 9:00

    IBM launched the first LDM-based database product, 'SQL Data Insights,' which ships as part of DB2 for ZOS. A follow-up version, 'SQL Data Insights Pro,' extends this approach to unstructured text and adds incremental model refresh.

Watch on YouTube Full article

Introducing the SQL MCP Server - Jerry Nixon - NDC Toronto 2026 thumbnail

· 55:44

Introducing the SQL MCP Server - Jerry Nixon - NDC Toronto 2026

SQL MCP Server, an open-source component from Microsoft's data API builder, provides a secure and standardized abstraction layer for modern applications, especially those powered by AI agents. It allows external models to interact with enterprise databases (including SQL Server, PostgreSQL, Cosmos DB, and MySQL) without requiring direct T-SQL knowledge or exposing sensitive connection strings. The solution standardizes database access into three endpoints—REST, GraphQL, and MCP—simplifying the development process and significantly enhancing security by enforcing policies at the API layer.

Key takeaways

  1. Unified Data Access Layer 2:00

    The SQL MCP Server acts as a single point of entry for all data interactions, supporting multiple database types (SQL, NoSQL) and exposing three standardized APIs: REST, GraphQL, and the specialized Model Control Protocol (MCP). This abstraction layer allows developers to write code against the API surface rather than directly against the underlying schema.

  2. AI Agent Integration via MCP 8:00

    For AI agents, which cannot speak directly to a database, the MCP endpoint is critical. It collapses the potential hundreds of CRUD tools (one per table) into a standardized set of seven tools (Describe Entities, Create, Read, Update, Delete, etc.), preventing model overload and ensuring reliable agentic workflows.

  3. Simplified Development & CI/CD 3:00

    The solution aims to eliminate the need for boilerplate CRUD API code in a codebase. By using data API builder, developers can significantly reduce complexity and potential errors, streamlining the CI/CD pipeline while maintaining high functionality.

  4. Advanced Security & Policy Enforcement 10:50

    Security policies (like Row-Level Security) can be enforced at the API layer, even if structural changes are impossible in the underlying database. Furthermore, it supports advanced authentication methods like OpenID Connect and On Behalf Of (OBO) pass-through authentication.

Watch on YouTube Full article