add npr api scripts
add the support of sqlit