@svpino: New database guarantees for agentic workflows: 1. Branches: Give agents a separate version of the data for running expe…
Summary
The article discusses new database guarantees for agentic workflows, such as branches and isolation, and introduces Tencent Cloud's TDSQL-C PostgreSQL product as the first to offer all four key features.
View Cached Full Text
Cached at: 09/26/26, 12:45 AM
New database guarantees for agentic workflows:
-
Branches: Give agents a separate version of the data for running experiments, then inspect, discard, or roll back its changes.
-
Isolation: Give agents their own database environment and restrict what they can access.
-
Automatic provisioning and scaling: Create environments quickly, handle bursts of activity, and scale compute to zero between runs.
-
Agent access and memory: Expose data through MCP and support vector retrieval for finding relevant information.
Any application can benefit from these, but they are crucial for agentic workflows.
The first provider to offer all four is Tencent Cloud, with its new Cloud Native Database TDSQL-C PostgreSQL.
It uses Copy-on-Write behind the scenes, letting multiple versions of the data share the same underlying storage until one changes something.
Imagine you want to give an agent a copy of your 1 TB database. Here is how it works:
-
The system creates a branch that points to the existing data. No need to copy the whole terabyte.
-
The agent reads from that branch.
-
If the agent modifies something, the system will store a separate version of the affected portion for its branch.
-
Changes in the branch leave the original database unchanged.
-
If the experiment fails, you can delete its branch without changing the original database.
The product details are here: https://tencentcloud.com/products/tdsqlc
Thanks to the Tencent Cloud team for partnering with me on this post.
Cloud Native Database TDSQL-C | Tencent Cloud
Source: https://www.tencentcloud.com/products/tdsqlc
Overview
Cloud Native Database TDSQL-C (TDSQL-C for short) is a new-generation cloud native relational database developed by Tencent Cloud. It combines the strengths of traditional databases, cloud computing, and cutting-edge hardware technologies to provide elastically scalable database services featuring high performance, security, and reliability, as well as full compatibility with MySQL and PostgreSQL. It can deliver a high throughput of over one million QPS and a smart storage capacity up to the petabyte level, fully ensuring data security and reliability.
Benefits

High Compatibility
Work well with open-source MySQL 5.7, MySQL 8.0 and PostgreSQL 10 engines. It supports queries of existing databases as well as migration of their applications and tools with minimal code change.

Ultra-High Performance
Sustain millions of QPS on a single node for scenarios requiring high concurrency and performance, ensuring the continuity of critical workloads. It also provides read/write separation and scalability.

Massive Storage Capacity
It offers massive storage of up to petabyte level, a serverless architecture, features auto scaling, fault checks, and auto-repairs, helping you cope with the dynamic changes and continuous growth of your business data volume.

Fast Recovery
Support for instant failover and recovery on stateless compute nodes. Even a failed physical machine can be recovered in less than one minute on a compute node.

High Data Reliability
Support security group and VPC network isolation. It also automatically maintains multiple replicas of data and backups to ensure data security and an availability up to nine nines.

Elastic Scalability
Add 1-15 read-only compute nodes to a cluster in seconds based on workloads, enabling fast response to business surges and fluctuations.
Features
VPC
A VPC allows you to create an independent network space in the cloud and launch cloud resources in that virtual network. You can also connect your IDC and the VPC via VPN or Direct Connect to use Tencent Cloud as an extension of your IDC.
Security Group
A security group is a stateful virtual firewall with filtering capabilities. It is used in Tencent Cloud as an important means of network security isolation, and it can be used to set network access controls for one or more CVM instances.
Multiple Layers of Security Protection
TDSQL-C provides multiple layers of security protection by default, helping defend against various attack traffic for business continuity in case of DDoS attacks. It can effectively block database attacks such as SQL injections and brute force attacks, reducing business interruptions and losses.
Comprehensive Daily Monitoring
TDSQL-C offers many common database performance metrics that can be monitored at the minute level in real time. It supports custom alarms for these metrics and sends notifications to Ops personnel upon alarm triggering, allowing them to quickly respond to the problems. It also provides reports on slow query analysis and SQL running for download, enabling you to identify factors affecting database performance.
Finer Granularity Monitoring
TDSQL-C provides 15 core database performance metrics that can be monitored at the second level in real time, helping you keep track of the health of your instances and quickly locate performance issues.
Database Logs
Slow query logs and error logs can be downloaded to help you understand the factors affecting your database performance.
Scenarios
Performance-Intensive Applications
Internet and Gaming Workloads
- TDSQL-C offers commercial-grade performance and reliability at low costs, making it an ideal choice for mission-critical businesses.
- TDSQL-C ensures your business stability with multiple customized kernel optimizations and enterprise-grade features, allowing R&D personnel to focus more on development.
- TDSQL-C is compatible with open-source MySQL and PostgreSQL, helping you cloudify your business smoothly.

- TDSQL-C features flexible scalability with no upfront payment. It can scale up and down in minutes and has a pay-as-you-go storage capacity of up to petabyte level to help you manage business peaks.
- TDSQL-C allows multiple regions to use the same server, removing the need for time-consuming region and server merges.
- TDSQL-C offers fast snapshot backup and rollback, making it ideal for the internet and gaming industries.

Pricing
TDSQL-C offers three billing options: monthly subscription, pay-as-you-go, and serverless. Prices vary by country/region. For more information, seeBilling Overview.
Similar Articles
@TencentAI_News: PostgreSQL just landed in CloudBase With CloudBase, your Vibe Coding product can spin up its own database with a single…
Tencent CloudBase adds PostgreSQL support, letting AI coding agents spin up isolated databases with a single prompt, with SQL-declared permissions and row-level security.
SQLite is all you need for durable workflows
This blog post argues that SQLite, combined with Litestream for async backups, provides a simple and effective approach to durable execution for many workflow systems, especially AI agents, without needing a separate orchestration tier or network database.
@servasyy_ai: https://x.com/servasyy_ai/status/2057463627255570937
Tencent Cloud database team open-sourced TencentDB Agent Memory, a runtime system that solves the context degradation problem in long tasks for AI agents, compressing short-term context into the memory system through three-layer backtracking and dynamic compression, and integrating a long-term memory pipeline. This is a landmark attempt for AI agent memory systems moving from 'database' to 'runtime'.
Postgres transactions are a distributed systems superpower
This article explains how using Postgres transactions for workflow state co-located with application data eliminates idempotency and atomicity problems in distributed workflows, providing exactly-once execution.
@aparnadhinak: https://x.com/aparnadhinak/status/2062233330196926720
A Twitter thread discussing whether a database filesystem abstraction (PostgresFS) or a skill-based approach with local Bash is better for agent workflows. The skill approach wins on composability and speed.