Connecting to AGENT SQL
Learn how to establish JDBC connections using the AGENT SQL driver, configure connection parameters, and authenticate with your API key for secure database access.
AGENT SQL
AGENT SQL provides a powerful SQL interface for executing differential privacy queries directly on data stored in the AGENT platform. Using standard JDBC connectivity, you can connect popular SQL clients and applications to analyze sensitive data while maintaining strict privacy guarantees through epsilon and delta parameters.
Getting Started
Begin your AGENT SQL journey by establishing a connection using the JDBC driver and your API credentials. All queries require a differential privacy clause (WITH DP(epsilon=..., delta=...)) to ensure privacy-preserving analysis. The platform supports standard SQL operations including aggregations, mathematical functions, date operations, and complex grouping while automatically preventing privacy violations.
Supported Workbenches
AGENT SQL integrates seamlessly with popular SQL client applications through JDBC connectivity. Each client requires the AGENT SQL JDBC driver and proper configuration of connection parameters including your API key and privacy budget settings.
DBeaver
Step-by-step instructions for connecting the popular open-source database tool to AGENT SQL using Apache Calcite Avatica driver configuration.
SQL Workbench
Configuration guide for SQL Workbench/J, a cross-platform SQL query tool, with AGENT SQL JDBC driver setup and connection management.
Java Client
Programmatic access to AGENT SQL through Java applications using JDBC connections, with code examples and best practices for integration.
AGENT Client
Native AGENT client application for executing SQL queries with built-in privacy budget management and streamlined authentication.
Tableau (Under Development)
Future integration with Tableau for visual analytics on privacy-protected data through AGENT SQL connectivity and custom connectors.