Hi, I’m a beginner ERPNext dev. Just wanna know how I could customize database tables, mainly just to CRUD tables in the existing mariadb database.
Any documentation/tutorial vids would be extremely helpful. Thanks in advance.
Hey buddy, welcome 
I’m also quite new and self taught.
As far as I know, you can do the following:
1- Just create new doctypes, add fields, link them, etc. ( that’s basically building new stuff in the database through the GUI in easiest way possible)
2- Search for “System Console” you can run Python and SQL commands ( although limited permissions )
3- Run " bench --help " in your server’s frappe-bench folder, you will see many commands, If I remember correctly you can access the database with something like " bench --site your.site.com MySQL "
4- Install extra Apps " Insights " and " Commit "
1 Like