Remove / ignore prefix with database name while autocomplete of SQL, when having multiple databases in PhpStorm / Idea, so that code completion do not prefix table names with database name

Open IDE and go to:

File | Settings | Languages & Frameworks | SQL Resolution Scopes

Set default project mapping to single database or set different database, on specific directories inside project

In case after this change Jetbrains IDE does not recognize table names and columns, try to click ALT + ENTER and try to execute “Run query in console” inside database you want, this should fix issue

Second option is to remove database prefixes in:

File | Settings | Editor | General | Smart Keys | SQL

Change “On Collisions” setting in for Table, in qualify settings