Extending Prisma 8 with Typed Postgres ltree
GA3 months agoUnverifiedAdded Sep 24, 2026
Prisma 8 now supports PostgreSQL ltree via prisma-ltree, providing typed path columns and ancestor/descendant query capabilities.
Topics: Postgres
More Prisma Postgres releases
Every Prisma Postgres releasePostgres Full-Text Search Instead of Elasticsearch
Prisma Postgres now supports full-text search using tsvector, GIN indexes, and pg_trgm for typo tolerance, removing the need for Elasticsearch in most applications.
Prisma Studio Migrations View: See Your Migration History
The Prisma Studio Migrations view now displays a timeline of applied migrations, including visual diffs, executed SQL, and schema changes.
Build a Postgres Job Queue with SKIP LOCKED, No Redis
Prisma Postgres now supports reliable background job queues using FOR UPDATE SKIP LOCKED, eliminating the need for an external broker like Redis.
Ship risky schema changes with per-branch databases
Prisma Compute now provides each branch with its own isolated Prisma Postgres database, allowing for testing of schema migrations.
Prisma Object Store Buckets: S3-Compatible File Storage
Prisma now provides S3-compatible file storage buckets that can be managed via API calls, allowing agents to read and write files.
Search encrypted data with Prisma 8 and CipherStash
Prisma 8 now supports searchable field-level encryption via CipherStash, enabling equality, free-text, and range queries on encrypted data.
Don't Let Your AI Agent Delete Your Production Database | Prisma 8
Prisma 8 includes structural changes to prevent AI agents from accidentally deleting production databases, including the removal of reset commands and shadow databases.
You Don't Need a Vector Database, Postgres Already Has pgvector
Prisma 8 now provides type-safe support for pgvector, enabling semantic search directly within Postgres.
Also shipped on Jul 20, 2026
Prisma in July 2026Lakehouse : Cross-cloud Lakehouse now supports integration with SAP Business Data Cloud (BDC) in Preview
Lakehouse : Cross-cloud Lakehouse now supports integration with SAP Business Data Cloud (BDC) in Preview. This update includes the following features: Federation from SAP BDC: Create Delta Sharing catalogs in Lakehouse to automatically synchronize shares, schemas, and tables from SAP BDC.
OIDC federated authentication (Public Preview)
OpenID Connect (OIDC) security integrations for federated single sign-on (SSO) are available in Public Preview. Multiple OIDC integrations, or OIDC alongside an existing SAML2 integration, require identifier-first login . Without identifier-first login, only one SSO integration (SAML2 or OIDC) can be ENABLED=TRUE at a time.
DML into frozen regions of dynamic tables (General availability)
You can now use DML statements (INSERT, UPDATE, MERGE, DELETE) to modify rows directly in the frozen region of a dynamic table. This enables use cases such as GDPR-required row deletions or correcting specific records without triggering a full refresh of the active region. For more information, see DML into a frozen region .
Pass-through policies for dynamic tables with incremental refresh (General availability)
Dynamic tables that have base tables with arbitrary masking or row access policies can now maintain incremental refresh when the policy is pass-through for the role used during refresh (that is, when the refresh role has unrestricted access to all rows and columns regardless of the policy condition).
[In preview] Public Preview: Protect sensitive generative AI telemetry in Application Insights and Microsoft Foundry
Azure Monitor Application Insights now stores generative AI content in a dedicated GenAIContent table (AppGenAIContent in Log Analytics), making it possible to apply newly available access controls to sensitive AI telemetry. Because Application Insights p
AI credit pools for cost centers in the billing UI
You can now manage a cost center’s AI credit pool directly in the billing UI where you create and edit cost centers. Previously, you could only manage this through the GitHub REST API. This feature is available for Copilot Business and Copilot Enterprise on GitHub Enterprise Cloud. Toggle the AI credit pool on when you create or edit a cost center.