I am trying to create an API using Strapi CMS. I have an existing postgres + postgis database and i would like to connect-use this database in a Strapi project.
Do you know if it is possible to do something like this? Thank you in advance
I was looking for an answer for this also, but it seems the only answer is no, because Strapi is not schema-agnostic: you must adopt their database structure to use Strapi.
Now if I could only figure out a way to ask Stack Overflow for a schema-agnostic headless CMS ... without getting it flagged as an invalid/subjective question ...
You can do it while you create a strapi app just choose custom and setup the database there. and to import existing tables from that db just create a mock table using strapi admin panel and in /api folder in your project root folder and copy paste the table data you just created in api folder and chage the name of that folder to the table name and do same for the files in side that folder and,
in the api>(your table folder)>config>routes.json file change the name of table inside I will add a link to help you better understand.
for setup in strapi with existing database> configure-strapi-postgresql
I couldn't find the tut for setting up exist but this is for mysql setps are smilers.
The best way is to create a new database with the same structure but created with strapi and after migrate the data.