Integrações e adaptadores do GizmoSQL

// Maven: com.gizmodata:gizmosql-jdbc-driver:1.7.0
String url = "jdbc:gizmosql://your-server.example.com:31337?useEncryption=true";

try (Connection conn = DriverManager.getConnection(url, "user", "password");
     Statement stmt = conn.createStatement();
     ResultSet rs = stmt.executeQuery("SELECT * FROM my_table")) {
    while (rs.next()) {
        System.out.println(rs.getString(1));
    }
}

claude mcp add gizmosql \
  -e GIZMOSQL_HOST=gizmosql.internal.example.com \
  -e GIZMOSQL_PORT=31337 \
  -e GIZMOSQL_USERNAME=analyst \
  -e GIZMOSQL_PASSWORD='your-password' \
  -- npx -y @gizmodata/gizmosql-mcp

pip install gizmosql-pdf-loader

# .env: GIZMOSQL_HOSTNAME, GIZMOSQL_PORT, GIZMOSQL_USERNAME, GIZMOSQL_PASSWORD,
#       GIZMOSQL_CATALOG (required), GIZMOSQL_SCHEMA (default: pdf_docs)
gizmosql-pdf-loader load --source-dir source_pdf_files
gizmosql-pdf-loader list
gizmosql-pdf-loader search "hydraulic pump relief valves" --ranked --limit 5

# Then from any SQL client:
#   SELECT file_name, page_number, score, snippet
#     FROM my_lake.pdf_docs.search_pages_ranked('hydraulic pump relief valves', top_k := 10);

# python -m pip install dbt-core dbt-gizmosql
my-gizmosql-db:
  target: dev
  outputs:
    dev:
      type: gizmosql
      host: gizmosql.example.com
      port: 31337
      auth_type: external   # browser-based OAuth/SSO
      use_encryption: True
      threads: 2

1# pip install sqlframe-gizmosql
2from sqlframe_gizmosql import GizmoSQLSession
3
4session = GizmoSQLSession.builder \
5    .config("gizmosql.uri", "gizmosql://localhost:31337") \
6    .config("gizmosql.username", "gizmosql_user") \
7    .config("gizmosql.password", "gizmosql_password") \
8    .config("gizmosql.tls_skip_verify", True) \
9    .getOrCreate()
10
11df = session.sql("SELECT 1 as id, 'hello' as message")
12df.show()

1# pip install sqlalchemy-gizmosql-adbc-dialect
2url = URL.create(drivername="gizmosql",
3                 host="localhost",
4                 port=31337,
5                 username=os.getenv("GIZMOSQL_USERNAME", "gizmosql_username"),
6                 password=os.getenv("GIZMOSQL_PASSWORD", "gizmosql_password"),
7                 query={"disableCertificateVerification": "True",
8                        "useEncryption": "True"})
9engine = create_engine(url=url)

1# pip install ibis-gizmosql
2import ibis
3
4con = ibis.gizmosql.connect(host="localhost",
5                            user=os.getenv("GIZMOSQL_USERNAME", "gizmosql_user"),
6                            password=os.getenv("GIZMOSQL_PASSWORD", "gizmosql_password"),
7                            port=31337,
8                            use_encryption=True,
9                            disable_certificate_verification=True)
10print(con.tables)
11t = con.table('lineitem')

1# brew install gizmodata/tap/gizmosql-odbc
2import pyodbc
3conn = pyodbc.connect(
4    "Driver=GizmoSQL ODBC Driver;"
5    "host=localhost;"
6    "port=31337;"
7    "uid=gizmosql_user;"
8    "pwd=gizmosql_password;"
9    "useEncryption=true"
10)
11cursor = conn.cursor()
12cursor.execute("SELECT * FROM my_table LIMIT 10")

SELECT
  order_date AS time,
  SUM(total_price) AS revenue
FROM orders
WHERE $__timeFilter
GROUP BY order_date
ORDER BY time

// npm install @gizmodata/gizmosql-client
import { FlightSQLClient } from "@gizmodata/gizmosql-client";

const client = new FlightSQLClient({
  host: "localhost",
  port: 31337,
  tlsSkipVerify: true,
  username: "gizmosql",
  password: "your-password",
});

// Positional parameters, in placeholder order
const table = await client.execute(
  "SELECT id, name FROM users WHERE id = ? AND name = ?",
  [42, "Alice"]
);
console.log(table.toArray());
await client.close();

pip install flight-sql-websocket-proxy
flight-sql-websocket-proxy-server --help
#   --port INTEGER              Run the websocket server on this port.
#   --tls CERTFILE KEYFILE      Enable transport-level security (TLS/SSL).
#   --database-server-uri TEXT  The URI of the Arrow Flight SQL server.