connect-to-the-database.md

Connect to the Database

SQL Clients

Use any of these popular tools to connect to PostgresML and write SQL queries

• Apache Superset
• DBeaver
• Data Grip
• Postico 2
• Popsql
• Tableau
• PowerBI
• Jupyter
• VSCode

SQL Libraries

Connect directly to the database with your favorite programming language

• C++: libpqxx
• C#: Npgsql,Dapper, or Entity Framework Core
• Elixir: ecto or Postgrex
• Go: pgx, pg or Bun
• Haskell: postgresql-simple
• Java & Scala: JDBC or Slick
• Julia: LibPQ.jl
• Lua: pgmoon
• Node: node-postgres, pg-promise, or Sequelize
• Perl: DBD::Pg
• PHP: Laravel or PHP
• Python: psycopg2, SQLAlchemy, or Django
• R: DBI or dbx
• Ruby: pg or Rails
• Rust: postgres, SQLx or Diesel
• Swift: PostgresNIO or PostgresClientKit