add database sql file, add route for api calls