Introducing the SingleStore Materialization Connector

Directly Sync Data Into SingleStore with a Seamless Integration

Our latest destination connector lets you store all your data with SingleStore, a fast cloud database-as-a-service. Built for streaming, SingleStore pairs perfectly with Estuary’s right-time data, down to millisecond latency so you can power real-time analytics.

Estuary connects directly with SingleStore’s SQL database, giving Estuary the ability to automatically create tables and update schemas: our durable integration is about as hands-free as you can get when moving data.

Why It Matters

You can already save data to SingleStore using Estuary’s Kafka API compatibility layer, Dekaf. So, why a dedicated materialization connector using SingleStore’s MySQL driver?

Dekaf has a time and place. But sometimes you need full-strength.

By directly accessing SingleStore’s backing SQL, the new SingleStore connector provides:

• Automatic table creation: There’s no need to explicitly create tables, type out fields, or choose data types. Estuary will automatically create tables for any selected data collections you want to materialize.
• Built-in schema evolution: Similarly, there’s no need to manually update your resources when upstream data changes. Make use of Estuary’s automatic schema evolution to capture new data streams or expand column types.
• Additional security options: The new SingleStore connector provides advanced options for secure connections, like SSL mode and SSH forwarding.

Sync all your data without fuss. Whether you’re materializing one or hundreds of tables, setup is quick and straightforward.

Still want to use the Dekaf SingleStore connector? No problem. We’ll continue to maintain both so you can use exactly what’s right for your workflow.

Built for Enterprises

Like every connector in Estuary Flow, the SingleStore integration benefits from our unified, enterprise-ready platform:

• Real-Time + Batch in One Platform – Stream from hundreds of source connectors directly into SingleStore, whatever their cadence, for data at your fingertips.
• Declarative Pipelines – Simplify complex ingestion workflows while ensuring consistency and governance.
• Secure Deployment Options – Choose fully managed, hybrid, or bring-your-own-cloud (BYOC) deployments for full control and compliance.

Getting Started

To begin streaming data into SingleStore, you’ll need:

1. Connection details for your SingleStore instance (address, database user, and password)
2. SingleStore’s SSL certificate
3. At least one source collection

You can optionally configure settings around timezones, hard deletes, SSH forwarding, and more.

Once configured in Estuary’s web application (or via your catalog spec for code-driven workflows), your SingleStore database will be continuously updated with your source collection data and ready for action.

📚 Step-by-step setup instructions: Read the SingleStore Connector Documentation →

Estuary Flow’s new SingleStore destination connector lets you seamlessly ingest data from any source into a central location.