I like to define db schema in text file in a form of yaml or json or any other reasonable format. How can they be used in Base for importing table definitions ?
i tried to do this with Libre Calc files , but read only issues pops up with them, so gave it up.
There is nothing within Base to do what you are asking. Since Base is only a front end to a database, you could possibly write your own code to deal directly with whatever database you may be using. Within Base you could write macros to read your file and construct and execute the SQL necessary to create the tables.