Provides code to store AI prompts in a SQL-Server database.
Code for database operations is contained in a library project, which can be used with web or desktop solutions.
➰ A desktop project is included for easy testing.
There is a table for categories and prompts, which allows a user to categorize their prompts.
File logging is included.
Created with SSMS 18.9.1 and SQL-Server 2019.
Scripts and instructions are in the Scripts folder in the project PromptingLibrary.
| Column | Descritpion |
|---|---|
| PromptID | Primary key |
| Title | Description |
| PromptText | The prompt |
| CreatedAt | Created |
| LastUsedAt | Last use |
| UsageCount | How many times used |
| IsActive | Is currently being used |
- A history table for one-to-many versions of each prompt.
- Import/Export of prompts to a file to share with others.