PySqlit
Manages SQLite databases with comprehensive features for creation, table operations, data manipulation, backup, recovery, and import/export.
About
PySqlit is a comprehensive database operation toolset built upon the FastMCP framework and PySqlit library, designed to simplify and streamline SQLite database management. It offers a complete suite of functionalities, enabling users to effortlessly create and manage databases, perform detailed table operations including schema definition and deletion, and execute all essential data manipulation tasks like inserting, querying, updating, and deleting records, including batch operations. Furthermore, it provides critical administrative features such as robust database backup and recovery, and convenient data import/export capabilities via CSV files.
Key Features
- Advanced table operations (creation, deletion, schema inspection, record counting).
- Comprehensive SQLite database management (creation, backup, restore, info).
- 1 GitHub stars
- Seamless data import from and export to CSV files.
- Full data CRUD (Create, Read, Update, Delete) functionality, supporting single and batch insertions.
- Ability to execute custom SQL statements for flexible database interaction.
Use Cases
- Automating routine SQLite database administration tasks like backups and data migration.
- Developing applications that require robust embedded SQLite database management.
- Facilitating data exchange and synchronization between SQLite databases and CSV files.