Access Dashboard

Supported Databases

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

-- 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

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

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

Last updated