It's a pretty established convention that database table names, in SQL at least, should be singular. SELECT * FROM user; See this question and discussion. It's also a pretty established convention that RESTful API resource names should be plural.

Is database singular or plural?

The plural form of database is databases.

Are tables plural?

The plural form of table is tables.