# Supported DataSources

<figure><img src="https://2839184068-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fh3pxl4sSLyris6mbVyHW%2Fuploads%2FMAFEIVNLvBYsNtxLHJQz%2Fimage.png?alt=media&#x26;token=537cd539-4462-4690-b632-cb8b51daa4a1" alt=""><figcaption></figcaption></figure>

Syne works with all major database systems, providing native performance and database-specific features:

```sql
-- Prepared statements (postgresl, clickhouse)
PREPARE user_query (text) AS 
SELECT * FROM users WHERE name = $1;

EXECUTE user_query('john');

-- Admin commands (postgresql)
\d users
SHOW TABLES
```

#### SQL Databases

* **PostgreSQL** - Full `psql` client support, prepared statements, admin commands
* **MySQL** - Complete MySQL syntax support with native performance
* **SQL Server** - T-SQL support with Microsoft SQL Server features
* **Oracle** - Oracle SQL and PL/SQL support
* **ClickHouse** - Native ClickHouse client commands and analytics features
* **Amazon Redshift** - Optimized for data warehouse queries
* **Databricks SQL** - Spark SQL support for big data analytics

#### PostgreSQL-Compatible

* **Neon Postgres** - Serverless PostgreSQL with full compatibility
* **Supabase PostgreSQL** - Real-time PostgreSQL with extended features

#### NoSQL Databases

* **MongoDB** - Native `Mongosh` support + SQL queries via zero-SQL bridge
* **Cassandra** - CQL (Cassandra Query Language) support
* **ScyllaDB** - High-performance Cassandra-compatible database
* Google Analytics - SQL Supported G4A Reports.
* Posthog - SQL on Posthog data.

```sql
// Mongosh style
db.users.find({ status: "active" })

// Or use SQL on the same MongoDB data
SELECT * FROM users WHERE status = 'active'
```
