Metadata-Version: 2.3
Name: aws_redshift_schema_explorer
Version: 0.1.1
Summary: A Python library for extracting AWS Redshift schema metadata as structured dataclasses, designed for AI text-to-SQL applications.
License: MIT
Author: Sanhe Hu
Author-email: husanhe@email.com
Maintainer: Sanhe Hu
Maintainer-email: husanhe@email.com
Requires-Python: >=3.10,<4.0
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.10
Classifier: Programming Language :: Python :: 3.11
Classifier: Programming Language :: Python :: 3.12
Classifier: Programming Language :: Python :: 3.13
Provides-Extra: auto
Provides-Extra: dev
Provides-Extra: doc
Provides-Extra: test
Requires-Dist: Sphinx (>=7.4.7,<8.0.0) ; extra == "doc"
Requires-Dist: boto3 (>=1.37.38,<2.0.0) ; extra == "test"
Requires-Dist: boto3-stubs[redshift,redshift-data,redshift-serverless] (>=1.37.38,<2.0.0) ; extra == "dev"
Requires-Dist: boto_session_manager (>=1.8.1,<2.0.0) ; extra == "test"
Requires-Dist: build (>=1.2.1,<2.0.0) ; extra == "dev"
Requires-Dist: docfly (==3.0.0) ; extra == "doc"
Requires-Dist: enum_mate (>=0.1.1,<1.0.0)
Requires-Dist: furo (==2024.8.6) ; extra == "doc"
Requires-Dist: ipython (>=8.18.1,<8.19.0) ; extra == "doc"
Requires-Dist: nbsphinx (>=0.8.12,<1.0.0) ; extra == "doc"
Requires-Dist: pygments (>=2.18.0,<3.0.0) ; extra == "doc"
Requires-Dist: pytest (>=8.2.2,<9.0.0) ; extra == "test"
Requires-Dist: pytest-cov (>=6.0.0,<7.0.0) ; extra == "test"
Requires-Dist: rich (>=13.8.1,<14.0.0) ; extra == "dev"
Requires-Dist: rstobj (==1.2.1) ; extra == "doc"
Requires-Dist: simple_aws_redshift (>=0.4.3,<1.0.0)
Requires-Dist: sphinx-copybutton (>=0.5.2,<1.0.0) ; extra == "doc"
Requires-Dist: sphinx-design (>=0.6.1,<1.0.0) ; extra == "doc"
Requires-Dist: sphinx-jinja (>=2.0.2,<3.0.0) ; extra == "doc"
Requires-Dist: twine (>=6.0.0,<7.0.0) ; extra == "dev"
Requires-Dist: wheel (>=0.45.0,<1.0.0) ; extra == "dev"
Project-URL: Changelog, https://github.com/MacHu-GWU/aws_redshift_schema_explorer-project/blob/main/release-history.rst
Project-URL: Documentation, https://aws-redshift-scehema-explorer.readthedocs.io/en/latest/
Project-URL: Download, https://pypi.org/pypi/aws-redshift-scehema-explorer#files
Project-URL: Homepage, https://github.com/MacHu-GWU/aws_redshift_schema_explorer-project
Project-URL: Issues, https://github.com/MacHu-GWU/aws_redshift_schema_explorer-project/issues
Project-URL: Repository, https://github.com/MacHu-GWU/aws_redshift_schema_explorer-project
Description-Content-Type: text/x-rst


.. image:: https://readthedocs.org/projects/aws-redshift-schema-explorer/badge/?version=latest
    :target: https://aws-redshift-schema-explorer.readthedocs.io/en/latest/
    :alt: Documentation Status

.. image:: https://github.com/MacHu-GWU/aws_redshift_schema_explorer-project/actions/workflows/main.yml/badge.svg
    :target: https://github.com/MacHu-GWU/aws_redshift_schema_explorer-project/actions?query=workflow:CI

.. image:: https://codecov.io/gh/MacHu-GWU/aws_redshift_schema_explorer-project/branch/main/graph/badge.svg
    :target: https://codecov.io/gh/MacHu-GWU/aws_redshift_schema_explorer-project

.. image:: https://img.shields.io/pypi/v/aws-redshift-schema-explorer.svg
    :target: https://pypi.python.org/pypi/aws-redshift-schema-explorer

.. image:: https://img.shields.io/pypi/l/aws-redshift-schema-explorer.svg
    :target: https://pypi.python.org/pypi/aws-redshift-schema-explorer

.. image:: https://img.shields.io/pypi/pyversions/aws-redshift-schema-explorer.svg
    :target: https://pypi.python.org/pypi/aws-redshift-schema-explorer

.. image:: https://img.shields.io/badge/✍️_Release_History!--None.svg?style=social&logo=github
    :target: https://github.com/MacHu-GWU/aws_redshift_schema_explorer-project/blob/main/release-history.rst

.. image:: https://img.shields.io/badge/⭐_Star_me_on_GitHub!--None.svg?style=social&logo=github
    :target: https://github.com/MacHu-GWU/aws_redshift_schema_explorer-project

------

.. image:: https://img.shields.io/badge/Link-API-blue.svg
    :target: https://aws-redshift-schema-explorer.readthedocs.io/en/latest/py-modindex.html

.. image:: https://img.shields.io/badge/Link-Install-blue.svg
    :target: `install`_

.. image:: https://img.shields.io/badge/Link-GitHub-blue.svg
    :target: https://github.com/MacHu-GWU/aws_redshift_schema_explorer-project

.. image:: https://img.shields.io/badge/Link-Submit_Issue-blue.svg
    :target: https://github.com/MacHu-GWU/aws_redshift_schema_explorer-project/issues

.. image:: https://img.shields.io/badge/Link-Request_Feature-blue.svg
    :target: https://github.com/MacHu-GWU/aws_redshift_schema_explorer-project/issues

.. image:: https://img.shields.io/badge/Link-Download-blue.svg
    :target: https://pypi.org/pypi/aws-redshift-schema-explorer#files


Welcome to ``aws_redshift_schema_explorer`` Documentation
==============================================================================
.. image:: https://aws-redshift-schema-explorer.readthedocs.io/en/latest/_static/aws_redshift_schema_explorer-logo.png
    :target: https://aws-redshift-schema-explorer.readthedocs.io/en/latest/

A Python library that provides a simple, structured interface for extracting AWS Redshift schema metadata. This project focuses purely on the extraction layer, offering clean command-pattern APIs to retrieve database, schema, table, view, and column information from Redshift clusters. The extracted metadata is returned as structured dataclasses, making it ideal for downstream applications like AI-powered text-to-SQL systems. The library handles the complexity of querying Redshift system tables and views, providing a clean abstraction for schema exploration without dictating how the metadata should be encoded or consumed.

Note: the sql command used in this project is based on `my own research <https://github.com/MacHu-GWU/tech_garden-project/blob/main/docs/source/486768641-Extract-Redshift-Schema-Details-For-AI/index.ipynb>`_.


.. _install:

Install
------------------------------------------------------------------------------

``aws_redshift_schema_explorer`` is released on PyPI, so all you need is to:

.. code-block:: console

    $ pip install aws-redshift-schema-explorer

To upgrade to latest version:

.. code-block:: console

    $ pip install --upgrade aws-redshift-schema-explorer

