Metadata-Version: 2.4
Name: psql-crud-tool
Version: 0.1.0
Summary: Interactive PostgreSQL CRUD CLI tool
Home-page: https://github.com/yourusername/crud_postgres
Author: Jagriti Srivastava
Author-email: your_email@example.com
Requires-Python: >=3.8
Description-Content-Type: text/markdown
Requires-Dist: psycopg2-binary

# PostgreSQL CRUD CLI Tool

An interactive command-line tool to perform CRUD operations on PostgreSQL databases and generate Python CRUD scripts automatically.

---

## Why Use This Tool

This tool is useful for developers who want to avoid writing repetitive CRUD operations and manually setting up PostgreSQL in their Python projects.

With this tool:

* The required PostgreSQL library is handled automatically
* A database can be created or selected
* A connection is established
* Tables are created dynamically
* A Python file is generated with basic CRUD operations

This helps developers save time and focus on application logic instead of setup and boilerplate code.

---

## Features

* Connect to PostgreSQL using username and password
* Create a new database or use an existing one
* Create tables dynamically
* Perform CRUD operations:

  * Insert
  * Read
  * Update
  * Delete
* Generate reusable Python CRUD code for your tables
* Simple and beginner-friendly command-line interface

---

## GitHub Repository

https://github.com/jagritiS/crud_postgres

---

## Installation

Install from PyPI:

```bash
pip install psql-crud-tool
```

---

## Usage

Run the CLI tool:

```bash
psqlcrud
```

---

## Example Workflow

1. Enter PostgreSQL credentials
2. Choose whether to use an existing database or create a new one
3. Enter table name
4. Define table columns
5. Use the menu to:

   * Insert data
   * Read data
   * Update records
   * Delete records
6. Generate a reusable CRUD Python file

---

## Generated File

The tool generates a file named:

```
crud_generated.py
```

This file includes basic functions for:

* Insert
* Read
* Update
* Delete

---

## Disclaimer

This tool is intended for learning and development purposes.
Avoid using raw input directly in production environments due to SQL injection risks.

---

## Author

Jagriti Srivastava

---

## License

MIT License

---

## Contributing

Contributions are welcome.
Feel free to fork the repository and submit pull requests.

---


