tentaclio_postgres_connection_and_pandas_sql_query.py

1import tentaclio
2import pandas as pd
3
4# The connection string for the postgres database
5# Format: postgresql://user:password@host:port/database
6POSTGRES_URL = "postgresql://username:password@localhost:5432/my_database"
7
8# Use tentaclio.open to create a connection client
9with tentaclio.make_db_client(POSTGRES_URL) as client:
10    # You can execute SQL directly or use it with pandas
11    query = "SELECT * FROM my_table LIMIT 10"
12    df = pd.read_sql(query, client.connection)
13
14print(df.head())