pythonrest3 0.4.1
A CLI tool that generates a complete API using a connection string for supported databases: mysql, mssql, mariadb and postgres
Keywords: api, rest api, database, python, mysql, mssql, postgres, aurora, mariadb

# PythonREST

PythonREST is the ultimate full API generator for Python language. Based on the best performing frameworks and software development best practices, PythonREST can create an entire CRUD API in minutes or seconds based on your relational database on a single CLI command. This allows you to create your APIs from scratch and update your current API previously created with our tool to always match your latest database definitions.

**THIS WILL SAVE YOU MONTHS OF DEVELOPMENT TIME, GUARANTEED!**

Your new generated API will have full CRUD compatibility with your mapped database and full Swagger documentation and specs available. With your new API in hand, you will be able to containerize or serverless deploy it to any local, private, and public cloud providers of your choice and use it at will! If you're interested in taking your API to the next level and don't know how, please inquire with us at the email below for consultancy services.

This project is under active enhancement, and we have several open GitHub issues to improve it further. If you're an Open Source enthusiast and wish to contribute, we'd be more than happy to have you on our team! Get in touch via [admin@seventechnologies.cloud](mailto:admin@seventechnologies.cloud) if you have any doubts or suggestions, and don't forget to star our repository!

### If you like our solution, please consider donating on our [Patreon campaign](https://www.patreon.com/seventechnologies)!

## Version Disclaimer

**Version 0.2.1**
* Added some quality of life improvements for Redoc building

**Version 0.2.4**
* Adding SSH and SSL connection methods (direct file provision only where applicable)
* Support for PostgreSQL MONEY type (mapped as a string in code)
* Implementation of GROUPBY SQL Statement as a header for table routes

**Version 0.2.6**
* Support for column names that contain unusual characters like '-', ' ', '.', '/', '\', ':', '~', '*', '+', '|', '@'

**Version 0.2.7**
* SQL Views are no longer listed as routes in the generated API
* Fixing some cases where exceptions were improperly returned as byte-like objects
* Fixing `[or]` filter in GET routes when using multiple query parameters simultaneously
* Improving rendering of Swagger and Redoc pages

**Version 0.2.8**
* Small fixes to swagger improved rendering

**Version 0.2.9**
* Support for columns named with Python reserved keywords

**Version 0.3.0**
* Adding fixed version for generated API libraries to avoid breaking changes

**Version 0.3.1**
* Setting READ COMMITTED isolation level on mysql and mariadb resolvers

**Version 0.3.2**
* Adding fix for search path option not working on some PostgreSQL environments

**Version 0.3.3**
* Adding powershell test scripts for mysql, postgresql and sqlserver

**Version 0.3.4**
* Fix CORS issue by properly configuration of after request decorator function.

**Version 0.3.5**
* Synchronization between the versions on PyPI and the releases on GitHub.

**Version 0.3.6**
* Introduced Model Context Protocol (MCP) endpoints for dynamic LLM configuration and interaction.

**Version 0.3.7**
* Adding metadata to reserved keyword formatter.

**Version 0.3.8**
* Consolidate mcp artifacts into a single h_MCP folder on generated API.

**Version 0.3.9**
* Improve AI model initialization for /mcp/ask.

**Version 0.4.0**
* Implementing encryption of environment variables.

**Version 0.4.1**
* Added api generation tests on validate pipeline.