Skip to content

Latest commit

 

History

History
27 lines (14 loc) · 1.82 KB

faq.md

File metadata and controls

27 lines (14 loc) · 1.82 KB

Frequently Asked Questions (FAQ)

Here are some frequently asked questions about the Smart Schema Builder tool:

  1. What databases are supported by the Smart Schema Builder tool?

    • The tool supports PostgreSQL, MySQL, and SQL Server databases.

  2. Can I use the tool without the OpenAI API for suggesting table names?

    • Yes, the tool can be used without the OpenAI API. If the OPENAI_API_KEY environment variable is not defined, the functionality dependent on the OpenAI API will be skipped.

  3. How can I contribute to the Smart Schema Builder project?

    • To contribute, please refer to the contributing guidelines available in the project's repository.

  4. How can I join the discussion?

  5. Does the Smart Schema Builder tool handle complex database relationships, such as many-to-many relationships?

    • No. The Smart Schema Builder tool is still in its early stages of development and should be used with caution. While the tool aims to automate the process of generating database schemas, it is essential to thoroughly review and validate the generated schema before deploying. It is recommended to perform extensive testing and validation to ensure the accuracy and integrity of the generated schema for your specific use case. Additionally, it's advisable to keep backups of your data.

  6. Can I exclude specific tables or columns from being included in the generated schema?

    • Yes, you can exclude specific tables or columns by modifying the code in the generate_sql_files.py script. Look for the relevant sections where tables and columns are processed, and add the necessary logic to exclude the desired tables or columns based on your criteria.