getschema_database_schema_retrieval_quickstart.py

1import getschema
2
3# Initialize the client with your connection string
4# Supported types include postgres, mysql, mssql, oracle, and snowflake
5db = getschema.connect("postgresql://user:password@localhost:5432/mydatabase")
6
7# Retrieve the schema for the entire database
8schema = db.get_schema()
9
10# Print the schema details
11for table in schema.tables:
12    print(f"Table: {table.name}")
13    for column in table.columns:
14        print(f"  - {column.name} ({column.type})")
15
16# Close the connection
17db.close()