Add a "copy as markdown" button for Table structure to be "AI prompt friendly"

[theoludwig]

Hey!

AdminNeo is great for testing SQL queries, checking the data and interacting with database. 👍
I hope that the project will keep being maintained in the long-term. I personally find that AdminNeo is the best among all alternatives tools. Thank you for this project, it's really useful!

However, in our AI era, I often need to provide the database structure/tables structure in the prompt, so that the AI can help me write SQL queries.

For now, I do it "manually" by selecting with the mouse the structure, and then copy:

However, I need to manually remove Select data, Show structure, Alter table, New item and format a bit to be "really usable".

A nice Quality Of Life improvement, could be to add a button "copy as markdown", which will copy the table structure, for example like that:

## Comments

| Column      | Type                       | Collation | Comment |
| :---------- | :------------------------- | :-------- | :------ |
| `id`        | `uuid [gen_random_uuid()]` |           |         |
| `userId`    | `uuid NULL`                |           |         |
| `content`   | `text`                     |           |         |
| `createdAt` | `timestamp [now()]`        |           |         |
| `updatedAt` | `timestamp NULL`           |           |         |
| `parentId`  | `uuid NULL`                |           |         |

Even outside of AI, it can be used for documentation or other purposes.

For reference another project implement this "copy markdown" button: https://tanstack.com/start/latest/docs/framework/react/overview

[peterpp]

Thank you for the kind words. Copying to markdown is an interesting idea, I will think about how to implement it (plugin or core function).

But do you know that we have also GeminiSqlPlugin? You can use it for writing AI prompts for Gemini right in the SQL command page.

[theoludwig]

Oh interesting, I didn't know there was a Gemini plugin.

Is there a easy way to install plugins with the Docker image?

[peterpp]

You can modify the file /var/www/html/adminneo-plugins.php inside the docker container or you can bind it like this:

docker run -d \
  --name adminneo \
  -p 8080:8080 \
  -v /path/to/custom/adminneo-plugins.php:/var/www/html/adminneo-plugins.php \
  adminneoorg/adminneo:latest

The content of the adminneo-plugins.php file is described here: https://www.adminneo.org/plugins#usage