How to create table documentation which includes all the tables that are present in Schema?

[Mihir Sabnis]

We plan to create table documentation in Confluence. Table documentation will include all the tables present in either schema or metadata tables present at our side. This table documentation supposed to be created dynamically. That means when we enhance schema for new tables or column addition or data type changes - the documentation in confluence also updated for same.

I tried to search - but as such no direct option available? /markdown support is present in Cloud Confluence - not clear on same as well?

Example of What supposed to Look Like in Confluence Cloud:

---

Table: CUSTOMERS

Columns:

Name	Data Type	Nullable	Default
CUSTOMERID	NUMBER(10)	NO
NAME	VARCHAR2(50)	YES
EMAIL	VARCHAR2(100)	YES
CREATEDDATE	DATE	NO	SYSDATE

Primary Key:

• CUSTOMERID

Foreign Keys:

• ORDERS -> CUSTOMERS (CUSTOMERID -> CUSTOMERID)

[Laura Campbell [Seibert Group]]

Hi @Mihir Sabnis and welcome to Community.

Could you provide a bit more context on the schema or metadata tables on your side? For example, are you talking about a custom database you use in your company? Or a specific tool?

If I understand correctly, you are looking for a way to query some kind of database regularly (daily?weekly? every 5 minutes?) to refresh the content on a Confluence page that displays details of the tables in your database.

What comes to mind is the app Pocket Query: https://marketplace.atlassian.com/apps/1211199/pocketquery-sql-rest-for-confluence?hosting=cloud&tab=overview although I don't know if it meets your needs. You will have to research the app.

There may be other apps on the Marketplace that could help as well; I suggest you search and try out a few.